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

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.

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

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

Regards,
Fred.

"rrupp" wrote in message
...
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.