adding in excel
 

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.

adding in excel
 

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.

adding in excel
 

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.

adding in excel
 

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