Count two columns of a sheet that each match specific criteria

Bob Schweighart

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.

Eric Law

@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.

Eric Law

@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.

Bob Schweighart

Thank you Eric, appreciate the response. It was successful.