Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » SUM FUNCTION HIDDEN ROWS

SUM FUNCTION HIDDEN ROWS

ResolvedVersion 2003

Thu 12 Aug 2010, 08:41 Delegate Simone said...

Simone has attended:
Excel Advanced course

SUM FUNCTION HIDDEN ROWS

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

Fri 13 Aug 2010, 21:02 Trainer Anthony said...

RE: SUM FUNCTION HIDDEN ROWS

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:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

SUM FUNCTION HIDDEN ROWS

SUM FUNCTION HIDDEN ROWS

RE: SUM FUNCTION HIDDEN ROWS

Excel articles

Excel tip:

Closing Multiple Open Worksheets At Once