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
-
Are you just trying to total the same cell in several worksheets (one for each cost centre)?
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.0 -
@dcgoodman We've got a useful series of Excel tutorials on AAT Comment which you might want to bookmark.
If 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*
0 -
I don't think I explained by query properly, sorry first time on the site. One sheet is main sheet with all info. I then was told to put into another sheet next to a listing of cost centres the values of actuals, estimated then differences columns. So started to panic could think which formulas would be best to use and how too. I started to filter all the cost centre totals, in the main sheet. Then is the sheet where the totals were required did vlookup the cost centre, went to main sheet selected the final totals that I had put in the sum of, entered.
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
Di0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 325 NEW! Qualifications 2022
- 160 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 95 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 275 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 202 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 583 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership