| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif count items not in data range
I am counting selection of hospital names from list I created. Some
hospitals are not on the list and I want to count these as one total number, with label "other." |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Countif count items not in data range
=SUMPRODUCT(--(A1:A20<""),--(NOT(ISNUMBER(MATCH(A1:A20,K1:K4,0)))))
where A1:A20 is the full list, K1:K4 is your list. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "jbanton" wrote in message ... I am counting selection of hospital names from list I created. Some hospitals are not on the list and I want to count these as one total number, with label "other." |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
| How do I count items within a date range in Excel? | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Describe high/low range with CountIf (ex. count if >90 and <100 | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Linear Mode
