Formula

[Guest]

What formula can I use to add a column of visible numbers without adding
numbers in the hiden rows?
This is what I have tried and it adds the hidden rows
=SUM(Production!F16:F81).

Thanks,
Bob

 

[Carim]

Hi Bob,

=Subtotal(9,Production!F16:F81)

should do the job ...
HTH
Carim

 

[Guest]

I cut and pasted the formula and it is still adding all the hidden cells in
that column.
Any suggestions.
Bob

 

[Carim]

Bob,

I thought your hidden rows where the result of a Filter ...

In your case, my suggestion would be to use to Insert Name Define all
cells in hidden rows and give this range the name Hidden...
Then your result will be = sum(wholerange)-sum(hidden)

HTH
Carim

 

[Carim]

Bob,

If you are using XL 2003, you may use :

=SUBTOTAL(109,yourRange)

Carim

 

[Guest]

I changed the 9 to 109 and it works great.

Thanks for your help.

Bob