Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » SUM FUNCTION HIDDEN ROWS
Resolved · Low Priority · Version 2003
Simone has attended:
Excel Advanced course
Sometimes I need to apply a filter or hide some lines of my spreadsheet. However, when I do a SUM function, it sums all the lines not only the ones being shown. What can I do to sum only what is being shown after applying the filter?
Thanks
Hi Simona, thanks for your query. You need to use the SUBTOTAL function to do this. Details are at the bottom of the page linked here:
http://www.contextures.com/xlFunctions01.html
Hope this helps,
Anthony
|
|
Excel tip:Trace Dependents / Precedents without the blue arrowsRather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula. |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
