=SUMPRODUCT(--(F4:F630),--(NOT(ISNUMBER(G4:G63))))

--

HTH

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


"mikeburg" wrote in
message ...

Works great, Bernie, for one worksheet.

However, I have another that I need to count, if range F4:F63 contains
an amount greater than zero AND if the corresponding row of G4:G63
contains a text string.

Any ideas?

In other words I need a count of the rows whose cells F4:F63 are
greater than zero AND whose cells G4:g63 contains text too.

I am new to VBA, so I really appreciate everyone helping me out. I
learn a lot from this!

mikeburg


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