Can I use COUNTIFS to count how many times criteria in two columns coincide?

John Michael (Mike) Munsil

This is what I have:

=COUNTIFS({Sheet - Sales Pipeline Range 4}, "1 - Prospect" , {Sheet - Sales Pipeline Range 1} , "John Michael (Mike) Munsil" })

I am in a Metrics sheet. I want to sum the number of times that my user name occurs in rows where the row also contains a cell contains "1 - Prospect".

Genevieve P.

Hi @John Michael (Mike) Munsil

It looks like you just have an incorrect } at the end of your formula!

The structure should be as follows:

=COUNTIFS({Range 1}, "Criteria 1", {Range 2}, "Criteria 2")

You have a } at the end, after the last criteria but before the end ). Try removing it:

=COUNTIFS({Sheet - Sales Pipeline Range 4}, "1 - Prospect" , {Sheet - Sales Pipeline Range 1} , "John Michael (Mike) Munsil")

Cheers!

Genevieve

John Michael (Mike) Munsil

Perfect! Thank you!

Genevieve P.

Hi @John Michael (Mike) Munsil

It looks like you just have an incorrect } at the end of your formula!

The structure should be as follows:

=COUNTIFS({Range 1}, "Criteria 1", {Range 2}, "Criteria 2")

You have a } at the end, after the last criteria but before the end ). Try removing it:

=COUNTIFS({Sheet - Sales Pipeline Range 4}, "1 - Prospect" , {Sheet - Sales Pipeline Range 1} , "John Michael (Mike) Munsil")

Cheers!

Genevieve

John Michael (Mike) Munsil

Perfect! Thank you!

John Michael (Mike) Munsil

Perfect! Thank you!