M
Matt Brewer
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!
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!