MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Getting a sum for only visible rows

Posted by Jim on June 21, 2000 8:08 AM

I have a list that will have autofilter enabled. I need to get the sum in one column of just the values that are visible after the filter. I figure I can do this with the SUMIF if I can put a formula in each row that will return a 1 or true if that row is visible.

Is there such a formula? Is there an easier way? I would prefer to do this without a macro, but will if necessary.


Posted by Jim on June 21, 0100 8:51 AM

I found the answer

The SUBTOTAL function ignores rows/columns that were hidden via a filter or autofilter.

FYI - If you need to ignore rows/columns that are hidden from a method other than filtering, see the attached link.