Hi,

Try

=COUNTIF(F4:F63,"0")

HTH,

David Jessop

"mikeburg" wrote:


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