SUMPRODUCT
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
|