Formula

Bob · Oct 9, 2006

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 · Oct 9, 2006

Hi Bob,

=Subtotal(9,Production!F16:F81)

should do the job ...
HTH
Carim

Bob · Oct 9, 2006

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

Carim · Oct 9, 2006

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 · Oct 9, 2006

Bob,

If you are using XL 2003, you may use :

=SUBTOTAL(109,yourRange)

Carim

Bob · Oct 9, 2006

I changed the 9 to 109 and it works great.

Thanks for your help.

Bob