ExcelBanter - COUNTIFS function ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - COUNTIFS function ? (https://www.excelbanter.com/excel-programming/412302-countifs-function.html)

Eng Teng

COUNTIFS function ?

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[_2_]

COUNTIFS function ?

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

COUNTIFS function ?

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

All times are GMT +1. The time now is 01:52 AM.