Sum formula

[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

 

[Guest]

Hi
if hidden by a filter try
=SUBTOTAL(9,A1:A100)

 

[Guest]

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

Hi
if hidden by a filter try
=SUBTOTAL(9,A1:A100)