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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!