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"))

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"))

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"))

Paul,

The ranges must be the same size. They do not have to start and end at the
same row/column, but the number of rows/columns being evaluated must be
similar.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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"))