Hi, cany anyone tell me why the following SUMPRODUCT Formula works

=SUMPRODUCT(--(MONTH(CountDate)=MONTH(B$2)),--(AreaCol=$A4),--
(SRACol=0.98),--(SRACol<=1.02))

Result is 195 which is correct.

And this one doesn't

=SUMPRODUCT(--(MONTH(CountDate)=MONTH(B$2)),--(AreaCol=$A4),--
(SRACol<0.98),--(SRACol1.02))

Result is 0, should be 16. If I only include one search for <0.98 or
1.02 then I get 7 + 9 respectively. Why does it not work when they
are combined as in the first formula.

Regards

Peter