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.

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.
--
** John C **

"Led_A_Muck" wrote:

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.

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

"Led_A_Muck" wrote in message
...
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.

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

--
Rui

"Led_A_Muck" wrote in message
...
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.