In your SUMPRODUCT formula, both arrays mus have the same number of lines

HTH
--
AP

"PaulW" a écrit dans le message de
...
I have a list including names, and codes that i want to count in a table.
There are mulitple names and codes to count.

I am using SUMPRODUCT but keep coming out with either #VALUE or #NA. I
have
looked at other postings but cannot see where i am going wrong.

Name Code
John A
Andy B
Steve C

my string at the moment is: -

=SUMPRODUCT(--('Payments Recevied -
Details'!$B$2:$B$65536="John"),--('Payments Recevied -
Details'!$G$39:$G$65536="A"))