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