| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting number of rows based on mutiple criteria
Does anyone know how to count the number of rows based on mutiple criteria on
other columns? For example I want to count the number row that meet the criteria of "Yes" in Col 2 and "Yes" in Col 3. The result would be 2 in the example below. I tried different combinations of Vlookup, Countif and Sumif and could not come up with anything that worked. Col 1 Col2 Col3 A Yes No B Yes Yes C No No D No Yes E Yes Yes Your help is greatly appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting the number of rows based on the color | Excel Discussion (Misc queries) | |||
| Counting number of rows between date range and meeting 2 string criteria | Excel Worksheet Functions | |||
| Count/Sum based on mutiple criteria | Excel Worksheet Functions | |||
| Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Threaded Mode
