COUNTIFS function ?

E

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countifs or a pivot 1
COUNTIFS function not supported in Excel 2003 2
How to get a value from 1 table to a 2nd. 15
Linking Child Timelines to Multiple Parents 0
Excel - Wich Function should I use? 1
Formula Question 2
VBA Linest function for polynomial regression on horizontal range 0
Removing Sequential Numbers 5

Top