| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIFS function | Excel Worksheet Functions | |||
| Excel 2007 countifs function problem | Excel Discussion (Misc queries) | |||
| Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr | Excel Worksheet Functions | |||
| COUNTIFS Function | Excel Worksheet Functions | |||
| translating countifs function to Excel 2003 | Excel Worksheet Functions | |||
Linear Mode
