I have the following data: https://docs.google.com/spreadsheets/d/16JyE91jVJ8CgLfBhlygQCA85xJs5cjQLojM6b318JNQ/edit#gid=0
In a single cell, I want to get the number of unique Countries & Cities with Status = "PENDING" and Special Package = "Yes" with out creating a new column. I tried using the following formula:
=COUNTUNIQUEIFS(ARRAYFORMULA(A2:A&B2:B),D2:D,"PENDING",E2:E,"Yes")
But it returns the error: Argument must be a range.