Hi,

I am stuck in something, probably because of the simple fact that I don't understand exactly how Frequency functions works inside of a COUNTIF or SUMIF.

I need to count the number of unique values in Column A, but dependent on some IFs for other columns, for example, in my printscreen attached, I need to see:

1. For Month 8, for Category A, for Time with "CAT", how many IDs do I have? For example, for ID "159" I should get value of "1" because I have at least one row having values Month-8, Time with-CAT and Category-A

Or

for ID 166 I should get only value "1" if I want to measure Month-9, Time with-Closure, Category-A

Sorry for my poor exaplanation Thanks for helping


Printscreen.jpg