SUMPRODUCT is the best!

=SUMPRODUCT((A1:A4<40)*(A1:A420))


"Eng Teng"
...
A
1 10
2 20
3 30
4 40

=COUNTIFS(A1:A4,"20",A1:A4,"<40")
ANSWER = 1

In excel 2003 COUNTIFS function not supported so How do I write in excel
2003 the formula?


Regards,
Tee