I need help. I have this:
I can tell my how many unique fruits are in column A with this array formula
And I can tell how many rows have both Apple in column A and 1 in column B with this array formula
But I can’t seem to figure out the formula to tell me the count of unique fruits that have a 1 in column B. The answer is two, apple and peach. What’s the formula that gets me there?