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

"Carim" wrote:

Hi Bob,

=Subtotal(9,Production!F16:F81)

should do the job ...
HTH
Carim