| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
COUNTIF with multiple disjoint ranges, same criteria
I cannot get COUNTIF to work with a non-contiguious range in my XL97, but if
this is something you have to do frequently, you may be interested in the "List Unique" feature of Jim Cone's commercial Add-in called XL Companion. It will list and count each and every value in a non-contiguious range. It's available at......... http://www.realezsites.com/bus/primitivesoftware Vaya con Dios, Chuck, CABGx3 "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 |
| 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 | |||
Linear Mode
