# Excel Formulas - Advice Needed

dcgoodman
Registered Posts:

**2**
Can anyone help,

I have forgotten my formula's for excel. What would be used if you have more than one sheet to collect the information from. Are there any example sheets I could practice on, ie, cost centres actual balances, estimated,ect,ect (from balance sheets)

Been out of the job for so long, so rusty, really what this job!

Thanks

Di

I have forgotten my formula's for excel. What would be used if you have more than one sheet to collect the information from. Are there any example sheets I could practice on, ie, cost centres actual balances, estimated,ect,ect (from balance sheets)

Been out of the job for so long, so rusty, really what this job!

Thanks

Di

0

## Comments

645In which case =SUM(sheetX:sheetY!cellref) where sheetX is the first sheet name and sheetY is the last sheet name should do it - assuming all the sheets are next to each other.

472If you have a MyAAT account you'll also have access to some free Excel e-learning as part of your AAT membership.

Stuart

*AAT Essentials - AAT's accounting and finance short courses**Watch: 6 reasons accountants make great friends*2I know this wasn't the correct way as it duplicated the same sum all done in the various cost centre.

What should I have used.

Hope that this makes it sense.

Thanks

Di