One way ..

Assuming the priority list of 22 nations is in D1:D22,
try in say, E1:
=SUMPRODUCT(--ISNUMBER(MATCH(B3:B850,D1:D22,0)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DKerr" wrote in
message ...

Hi,

I have a spreadsheet where cells B3:B850 show names of countries. I
have a list of 22 priority nations and would like a formula to count
the total number of occurances. I can count it my counting each of the
22 nations and adding this together, but can this be done in a single
formula? I am using Excel 97.

Thanks for any assistance.


--
DKerr
------------------------------------------------------------------------
DKerr's Profile:
http://www.excelforum.com/member.php...o&userid=13087
View this thread: http://www.excelforum.com/showthread...hreadid=515253