Hello Experts. I need your help. I've attached a worksheet to illustrate.

I'm using this function:

[=SUM(IF(FREQUENCY(L2:L11,

L2:L11)>0,1)*(M2:M11=0))]

First, I want to sum a column of unique numbers. The first half of this formula works for this.

[=SUM(IF(FREQUENCY(L2:L11,L2:L11)>0,1))]

Then, I want to modify the sum based on external criteria.

[*(M2:M11=0)]

I get an #N/A response.

I know I could *count the number of unique values by using a filter*. In this case I want to build a worksheet formula. Any insight on what I may be doing wrong here? Or could you suggest another approach? Frequency.xls
first instanceof each value in L2:L11 and count that only if it has a 0 in the corresponding row in M2:M11. If that's the case then it's actually a simpler version of the first formula I provided, i.e.=SUMPRODUCT((MATCH(L2:L11,

that will give you 3 for your example

regards, barry