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!