Sum formula

P

pauluk

Hi Kids of Excel,

just a little help please, what formula should i use to add a range o
cells up.

i have hidden a number of cells and want to add up the range which i
shown how do i do this (it can be alot of data sometimes)?

Thanks in advanc
 
P

Peo Sjoblom

Or if using excel 2003 you can use subtotal and it won't include hidden as in
(format>colums/rows>hide)

=SUBTOTAL(109,A1:A100)

Regards,

Peo Sjoblom

Frank Kabel said:
Hi
if hidden by a filter try
=SUBTOTAL(9,A1:A100)
Click to expand...
 
Top