Count two columns of a sheet that each match specific criteria
Hello, I am trying to create a count that both matches one of 4 specific project initiatives and shows approved in another column.
Example: Lead by Example (One Column) and the Status is "Approved" in another column.
Best Answer
-
@Bob Schweighart you just need the COUNTIFS formula and put those 2 criterion in it. Are they distinct counts for the 4 different projects? If so, that is easier. If you are counting all 4, then you need to decide on an imbedded OR or a NOT.
Answers
-
@Bob Schweighart you just need the COUNTIFS formula and put those 2 criterion in it. Are they distinct counts for the 4 different projects? If so, that is easier. If you are counting all 4, then you need to decide on an imbedded OR or a NOT.
-
Thank you Eric, appreciate the response. It was successful.
Help Article Resources
Categories
Check out the Formula Handbook template!