Something like =SUBTOTAL(109,A1:E1) should work in those circumstances.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"starguy" wrote in
message ...

I have hidden columns not rows. I hide them by both ways using Ctrl+9
and by menu Format Column Hide but nothing happened after hiding. I
also pressed F9 to recalculate after hiding columns.


Bob Phillips Wrote:
How have you hidden the rows?

--
HTH

Bob Phillips


--
starguy
------------------------------------------------------------------------
starguy's Profile:
http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=537953