Hello Experts. I need your help. I've attached a worksheet to illustrate.
I'm using this function:
First, I want to sum a column of unique numbers. The first half of this formula works for this.
Then, I want to modify the sum based on external criteria.
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