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
Try this formula with SUMPRODUCT
=SUMPRODUCT((MATCH(L2:L11&
doesn't need "array entering"
regards, barry