software

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=quot;Johnquot;),--('Payments Recevied -
Details'!$G$39:$G$65536=quot;Aquot;))
In your SUMPRODUCT formula, both arrays mus have the same number of lines

HTH
--
AP

quot;PaulWquot; gt; a écrit dans le message de
...
gt; I have a list including names, and codes that i want to count in a table.
gt; There are mulitple names and codes to count.
gt;
gt; I am using SUMPRODUCT but keep coming out with either #VALUE or #NA. I
have
gt; looked at other postings but cannot see where i am going wrong.
gt;
gt; Name Code
gt; John A
gt; Andy B
gt; Steve C
gt;
gt; my string at the moment is: -
gt;
gt; =SUMPRODUCT(--('Payments Recevied -
gt; Details'!$B$2:$B$65536=quot;Johnquot;),--('Payments Recevied -
gt; Details'!$G$39:$G$65536=quot;Aquot;))
gt;
gt;
Hi

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

Andy.

quot;PaulWquot; gt; wrote in message
...
gt;I have a list including names, and codes that i want to count in a table.
gt; There are mulitple names and codes to count.
gt;
gt; I am using SUMPRODUCT but keep coming out with either #VALUE or #NA. I
gt; have
gt; looked at other postings but cannot see where i am going wrong.
gt;
gt; Name Code
gt; John A
gt; Andy B
gt; Steve C
gt;
gt; my string at the moment is: -
gt;
gt; =SUMPRODUCT(--('Payments Recevied -
gt; Details'!$B$2:$B$65536=quot;Johnquot;),--('Payments Recevied -
gt; Details'!$G$39:$G$65536=quot;Aquot;))
gt;
gt;
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)

quot;PaulWquot; gt; wrote in message
...
gt; I have a list including names, and codes that i want to count in a table.
gt; There are mulitple names and codes to count.
gt;
gt; I am using SUMPRODUCT but keep coming out with either #VALUE or #NA. I
have
gt; looked at other postings but cannot see where i am going wrong.
gt;
gt; Name Code
gt; John A
gt; Andy B
gt; Steve C
gt;
gt; my string at the moment is: -
gt;
gt; =SUMPRODUCT(--('Payments Recevied -
gt; Details'!$B$2:$B$65536=quot;Johnquot;),--('Payments Recevied -
gt; Details'!$G$39:$G$65536=quot;Aquot;))
gt;
gt;