| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting rows that meet conditions in multiple columns
I want to count how many people who attended an event hold a certain status.
I've tried a number of formulas, including: =SUMPRODUCT((C2:C493="x")*(A2:A493="renewed")) and =SUMPRODUCT(--(C2:C493="x"),--(A2:A493="renewed")) (the "x" marks whether someone attended the event) =SUMPRODUCT(IF(ISNUMBER(SEARCH("Asia Trail", B1:B493)), IF(A2:A493="renewed",1))) where "Asia Trail" is one of several text values in a cell and I continue to get incorrect numbers. In other similar cells, I get zero when just looking at the sheet I know the number has to be in the 100's. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
| Counting # of cells with that meet criteria in two columns | Excel Worksheet Functions | |||
| count pieces of records meet conditions in different columns | Excel Worksheet Functions | |||
| Hiding rows that meet multiple conditions in excel | Excel Discussion (Misc queries) | |||
| counting cells in a data range that meet 3 specific conditions | Excel Discussion (Misc queries) | |||
Threaded Mode
