COUNTIFS function ?

[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

 

[Jim Cone]

See your other post.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"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

 

[Christopher Panadol]

SUMPRODUCT is the best!

=SUMPRODUCT((A1:A4<40)*(A1:A4>20))