2 Countifs Based on another Sheet
Could you help me with a Sheet Summary Formula where I need to both of the followingcriteria satisfied:
The column: Your region has the value of Americas
The column: Rating has the value of 5 Fantastic
My Formula is: COUNTIFS(([Your region]:[Your region], "Americas") AND ([Rating]:[Rating],"5 Fantastic"))
The result: UNPARSEABLE"
Thanks for your help! 😄
Help Article Resources
Check out the Formula Handbook template!