Help on Excel
System
Posts: 100,537 🤖 Admin 🤖
Hi All
I'm having a blonde moment again!!
I've created a spreadsheet for my friend's business so she can see clearly what her expenses ae going out on. I've done a seperate worksheet for each expenditure code but I can't remember how to get the total spent from each sheet onto the summary sheet that I've created at the end. It's been awhile since I've had to do this.
Hope someone can help!!

I'm having a blonde moment again!!
I've created a spreadsheet for my friend's business so she can see clearly what her expenses ae going out on. I've done a seperate worksheet for each expenditure code but I can't remember how to get the total spent from each sheet onto the summary sheet that I've created at the end. It's been awhile since I've had to do this.
Hope someone can help!!
0
Comments
-
Re:Help on Excel
In the cell where you want the information to go press = and then go to the cell where you want to take the information from and press enter.
Is that what you needed?
Annette0
Categories
- All Categories
- 1.4K Books to buy and sell
- 12.7K For AAT students
- 2.8K Student general
- 388 Qualifications 2022
- 171 General Qualifications 2022 discussion
- 16 AAT Level 2 Certificate in Accounting
- 78 AAT Level 3 Diploma in Accounting
- 115 AAT Level 4 Diploma in Professional Accounting
- 10.3K For accounting professionals
- 23 coronavirus (Covid-19)
- 276 VAT
- 97 Software
- 283 Tax
- 149 Bookkeeping
- 8.1K General accounting discussion
- 694 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 589 Job postings
- 16 Who can benefit from AAT?
- 37 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
- 67 AAT membership