SUMPRODUCT

P

PaulW

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

Guest

Hi

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

Andy.
 
B

Bob Phillips

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