Can I use COUNTIFS to count how many times criteria in two columns coincide?
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.
Best Answers

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

Perfect! Thank you!
Making mistakes is the fastest path to excellence.
Answers

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

Perfect! Thank you!
Making mistakes is the fastest path to excellence.

Perfect! Thank you!
Making mistakes is the fastest path to excellence.
Help Article Resources
Categories
Check out the Formula Handbook template!