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