Hello.
what I'm trying to accomplish is to count specific values in two columns in a worksheet (say, column A, and column B).
= countifs(column A, "Complete", column B, "Joe")
The above formula works for counting values in A, and B. Where my problem lies, is I want to only count values from the above formula based off distinct values in another column (say, column C). So, I want to count A = complete, and B = Joe, but if the value (numeric) is repeated in column C, then only return 1 for the count of "Complete, "Joe".
I hope the above makes sence. Thanks in advance for your help.
Bookmarks