Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto updating list | Excel Worksheet Functions | |||
How to pick one or more items out of a list, moving to new list, moving up or down. (form) | Excel Discussion (Misc queries) | |||
List of items appeared in range | Excel Worksheet Functions | |||
Count items on the list | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) |