hide row, don't want it to calculate in formula

rrupp · Mar 6, 2009

Is there a way to sum a column of data to NOT include hidden rows that are
dispersed sporadically throughout the worksheet? Excel 2003

Thanks.

Fred Smith · Mar 6, 2009

Yes. Use the Subtotal function, as in:
=subtotal(109,a:a)

Regards,
Fred.