View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] slingsh0t@hotmail.com is offline
external usenet poster
 
Posts: 6
Default Excel 2000 - Formulas and Functions

Try this one on for size:
=SUMPRODUCT(--(NOT(ISERROR(FIND("Japan",D3:D8,1)))))
where D3:D8 contains the list of countries. This works when the
countries are listed once per cell, as in your example "Japan, Italy".
"Japan, Italy, Japan" would yield only 1 in the count of Japan.