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.