| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count the frequency of items in a non-numeric list?
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
