exclude hidden rows from sum

I

Ian

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.
 
O

OssieMac

Hi again Ian,

The following ignores hidden rows:-

=SUBTOTAL(109,A1:A4)

Regards,

OssieMac
 
G

Gord Dibben

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
 
I

Ian

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