close
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 quot;other.quot;
=SUMPRODUCT(--(A1:A20lt;gt;quot;quot;),--(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)
quot;jbantonquot; gt; wrote in message
...
gt; I am counting selection of hospital names from list I created. Some
gt; hospitals are not on the list and I want to count these as one total
number,
gt; with label quot;other.quot;
全站熱搜
留言列表
