Count & If formula


I am trying to create a formula where I will get a count of total Solution Design by Zone.

I can get the count for each separately but I can't get it to combine. Column 1 - Zone & Column 2 - "Solution Design"

=COUNTIFS(Zone:Zone, ="West", "Solution Design":"Solution Design")

Thank you in advance.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!