Hi

Your ranges in SUMPRODUCT must be the same size. You are using B2:B65536 and
G39:G65536 - which are not!

Andy.

"PaulW" wrote in message
...
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"))