COUNTIFS function not supported in Excel 2003

[engteng]

Excel 2003 not support COUNTIFS function so How do I convert the
following formula in order to run on Excel 2007 ?

COUNTIFS('Raw Data'!$E:$E,"<=4",'Raw Data'!$I:$I,"1")

Regards,
Tee

 

[paul.robinson]

Hi
Try COUNTIF. There is no COUNTIFS function.
regards
Paul

 

[Mike H]

Maybe

=SUMPRODUCT(('Raw Data'!E1:E1000<=4)*('Raw Data'!L1:L1000=1))

Mike