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."

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."