Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sum Visible Cells only
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Sum Visible Cells only
Resolved · Urgent Priority · Version 2010
Reply Fri 13 Jan 2012, 17:04Delegate Sharon said...
Sharon has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Sum Visible Cells only
Sometimes when you have filtered on a spreadsheet you would then like to sum just the numbers left on the screen - If you highlight the numbers then the correct total appears in the sum box on the bottom of the screen but if you do a sum formulea on the spreadsheet itself it also adds the numbers that have been filtered as well - Basically I need a formulea that says sum visable cells only.
For upcoming training course dates see: Pricing & availability
RE: Sum Visible Cells only
Hello Sharon,
Hope you enjoyed your Microsoft Excel courses with Best STL.
Thank you for your question regarding summing visible cells only.
There are 2 ways you can do this.
1) Format the data as a table. Home ribbon > Styles > Format as Table. Then add the total row and whenever you filter the data the resulting totals will only be shown for the visible cells.
2) Should you not wish to work with the data formatted as a table then, apply a filter first, add the totals you require in the row of blank cells below the visible cells. These totals will only be for the visible cells. When you clear the filter the totals now shown will be for all the data.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Sun 22 Jan 2012: Automatically marked as resolved.
|