=COUNTIF(F4:F643,"0")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mikeburg" wrote in
message ...

What would be the simplest code to get a count of the number of cells in
a range F4:F63 that contains an amount greater then zero?

Thanks so much.

mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile:
http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=386450