I was hoping there was a formula (like a histogram) that would count the
countries so I wouldn't have to enter each country name individually into a
formula. I would only need to count the data in one column (the country
column) since the countries are entered multiple times (one line per
employee). (e.g., something that would count 4 occurences of Canada, 2 of
Belgium etc in this one column). Unfortunately, a histogram won't count
non-numeric text. Any ideas? RAR

"Dave F" wrote:

Use SUMPRODUCT

Assume employee name is in column A and country is in column B

=SUMPRODUCT((A1:100)*(B1:B100="USA")) would count the number of employees
that are in the USA. Replace "USA" with the country of your choice, and
adjust the ranges to suit your data.

Dave
--
Brevity is the soul of wit.


"RAR" wrote:

I have a list of employees (in Excel 2002) who are working in many different
countries. I want to calculate how many are in each country. How do I do
this?