=SUMPRODUCT(--(L12:L30=50),--(L12:L30<60))

--

HTH

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


"Souris" wrote in message
...
I have following VBA code

=COUNTIF(L12:L30,(AND("= 50","<60")))

I wanted to count if the value is greater and equals 50 and less than 60
in
range L12:L30, but it does not work.

It works if I use only one criteria like following.

=COUNTIF(L12:L30,"= 50")


Does COUNTIF suport more than one criteria?
Any information is great appreciated,