If you're using xl2003, you can use =subtotal(). This worksheet function has
been enhanced to include options to ignore manually hidden rows.

=subtotal(109,a2:a22)

for instance.

Afolabi wrote:

I have some rows manually hidden, Please is there a formula I can apply to
return the sum of the unhidden data contain in a column?

--

Dave Peterson