| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF with various criteria
I am using the following formulat to get the number of Boys from London
between the ages of 5 and 12. =SUMPRODUCT(--($D$3:$D$986="B"),--($F$3:$F$986=512),--($H$3:$H$986="London")) I must have done something wrong because I am not getting anything that makes sense. Can someone help please? Thank you -- NitaMax |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIf with 2 criteria possible? | Excel Discussion (Misc queries) | |||
| Countif with Two Criteria | Excel Worksheet Functions | |||
| Countif W/ 2 Criteria | Excel Worksheet Functions | |||
| Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Threaded Mode
