Getting #N/A Error for Array Formula (Entire Column)

[brandon12]

I attempted to modify the below formula to encompass more than the 13 rows (See original formula below):

Originally Posted by Eric W
H4:

Code:
=SUMPRODUCT(--(MATCH(B2:B13,B2:B13,0)=ROW(B2:B13)-ROW(B2)+1),--(COUNTIFS(B2:B13,B2:B13,C2:C13,"DA")=1),--(COUNTIFS(B2:B13,B2:B13,C2:C13,"THER NOTE")=1))
i4:

Code:
=SUMPRODUCT(--(MATCH(B2:B13,B2:B13,0)=ROW(B2:B13)-ROW(B2)+1),--(COUNTIFS(B2:B13,B2:B13,C2:C13,"DA")=1),--(COUNTIFS(B2:B13,B2:B13,C2:C13,"THER NOTE")>1))


The following is my modification but I'm getting a #N/A error:

=SUMPRODUCT(--(MATCH(B2:B,B2:B,0)=ROW(B2:B)-ROW(B2)+1),--(COUNTIFS(B2:B,B2:B,C2:C,"DA")=1),--(COUNTIFS(B2:B,B2:B,C2:C,"THER NOTE")>1))

Any suggestions on how to alleviate this problem as I will be using this formula in many spreadsheets with 1,000 or more rows each (none of which will be the same length).

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel...tance-duplicate-values-multiple-criteria.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.

You have already had an issue with Cross-Posting too, so please take the time to read all of the forum rules in the link above.