| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mulitiple Count of occurrences in different columns
=SUMPRODUCT(N(A1:A100="OLD"),N(B1:B100="HAPPY"),N( C1:C100=1),N(D1:D100="BLACK"))
"Ant" wrote in message ... Count of occurrences that appear in multiple columns. For example I have 5 columns that label a particular account as a "NEW" or "OLD", "HAPPY" or "SAD", "1" or "2", and "RED" or "BLACK". Each account has one of the labels and I want to count how many are labeled as "OLD", "HAPPY", "1", and "BLACK". I can't get the "COUNTIF", "COUNT(IF..." formula's to work. Can someone assist? -- Thank you, Ant |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count how many occurrences | Excel Discussion (Misc queries) | |||
| Count occurrences of dates | New Users to Excel | |||
| Count names and occurrences | Excel Worksheet Functions | |||
| How to count occurrences where 2 columns are required to be true? | Excel Worksheet Functions | |||
| Count unique occurrences of name | Excel Discussion (Misc queries) | |||
![Bob Umlas[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
