Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
COUNTIF with multiple disjoint ranges, same criteria
=SUMPRODUCT(COUNTIF(INDIRECT({"A1:C3","D4:F6","G7: I9"}),"Y"))
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Kurt Swanson" wrote in message ... 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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
COUNTIF with multiple disjoint ranges, same criteria
=SUMPRODUCT(COUNTIF(INDIRECT({"A1:C3","D4:F6","G7: I9"}),"Y"))
Nicely done, Bob! It works fine in my test. *********** Regards, Ron XL2002, WinXP-Pro "Bob Phillips" wrote: =SUMPRODUCT(COUNTIF(INDIRECT({"A1:C3","D4:F6","G7: I9"}),"Y")) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Kurt Swanson" wrote in message ... 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 |
Reply |
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 |