Excel Formulas - Advice Needed

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
In 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.
If you have a MyAAT account you'll also have access to some free Excel e-learning as part of your AAT membership.
Stuart
*Watch: 6 reasons accountants make great friends*
I 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