exclude hidden rows from sum

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

Guest

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average Question 2
sum entire column with heading rows 2
Sum of row excluding hidden columns 1
Blank Cells 3
Sum number range ignoring numbers formatted as text 0
Averaging non consecutive cells excluding zero's 4
Trying to return an array of numbers and choose the highest 33
Excel automatically changing my formula 7

Top