adding in excel

[Led_A_Muck]

How do you use the sum function in a column to add only the cells that are
visable not the hidden ones? I have several cells hidden and when I use the
sum function it adds all cells seen and un-seen.

 

[John C]

Are they hidden due to Filtering? Or why are they hidden.
If hidden due to filtering, read up on the SUBTOTAL function.
If not, provide more detail, formulas, sample, current result, expected
result.

 

[Peo Sjoblom]

Excel 2003 and later use subtotal

=SUBTOTAL(109,A1:A500)

will sum visible cells

if you are using a filter than this will work as well


=SUBTOTAL(9,A1:A500)

that works for earlier versions as well

--


Regards,


Peo Sjoblom

 

[ruic]

=sum(a1..a2)+sum(a4..a5) and so on and so on and so on