I am attempting to count if 2 criteria are met in one sheet that is not the sheet I am reporting to

HollyD · 09/01/22

Example: Count if "Won_2022" (in the first column) and "Phone Call" (in the second column). Thanks.

Tomasz Giba · 09/01/22

Is this what you're looking for?

Formula:

=COUNTIFS({first column range}, "Won_2022", {second column range}, "Phone Call")

Column ranges:

Tomasz Giba · 09/01/22

Is this what you're looking for?

Formula:

=COUNTIFS({first column range}, "Won_2022", {second column range}, "Phone Call")

Column ranges:

HollyD · 09/02/22

It worked! One character diff in what I was trying to do. Thank you so much!

Best Answer