| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
COUNTIF with multiple disjoint ranges, same criteria
This formula works as long as it is not located within A1:I9
=SUMPRODUCT(--((A1:C3:D4:F6:G7:I9)="Y")) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Kurt Swanson" wrote: Is there any way to specify multiple disjoint ranges in one COUNTIF? I.e. something like COUNTIF((A1:C3,D4:F6,G7:I9),"Y") I want to avoid COUNTIF(A1:C3,"Y") + COUNTIF(D4:F6,"Y") + ... -- © 2005 Kurt Swanson AB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countif using multiple criteria | Excel Discussion (Misc queries) | |||
| Counting Using Multiple Criteria | Excel Worksheet Functions | |||
| Countif w/ Multiple Criteria | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
| compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
Threaded Mode
