#### legalhustler

##### Well-known Member

- Joined
- Jun 5, 2014

- Messages
- 1,158

- Office Version
- 365

- Platform
- Windows

I have #N/A in the data array argument (in bold below) of the Frequency function when I evaluate the formula, which is correct because it's an item that does not match but when it sums it returns a #N/A. The sum should be 4 because there are 4 unique values (1, #N/A, 4, 3). Not sure how to get it sum to 4.

Evaluated formula:

SUM(IF(

Original Formula:

SUM(IF(

Evaluated formula:

SUM(IF(

**FREQUENCY({1;1;1;1;#N/A;4;4;3;3;3;#N/A}**,{1;2;3;4;5;6;7;8;9;10;11}),1))Original Formula:

SUM(IF(

**FREQUENCY(MATCH(MID(VAATB,Rules!$I$3,Rules!$G$3),**Rules!$E$3:$E$6,0),ROW(VAATB)-ROW($A$2)+1),1)
Last edited: