exclude hidden rows from sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there a way to exclude hidden rows when summing a column

eg: sum(A1:A4) but Row 3 is hidden so the result I want is =A1+A2+A4..

Thanks. Ian.
 
Ossiemac

This function was introduced in Excel 2003.

Prior to that SUBTOTAL would function only on rows hidden by autofilter as
pointed out in your first post.


Gord Dibben MS Excel MVP
 
The subtotal (109, [range]) worked perfectly (Excel 2003). Never knew the
function even existed. Thanks a lot guys. Ian.
 
Back
Top