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

Options

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

Making mistakes is the fastest path to excellence.

Options

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

Options

Perfect! Thank you!

Making mistakes is the fastest path to excellence.

Options

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

Options

Perfect! Thank you!

Making mistakes is the fastest path to excellence.

• Options

Perfect! Thank you!

Making mistakes is the fastest path to excellence.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!