Countif count items not in data range

J

jbanton

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

Bob Phillips

=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)
 
Top