Sumproduct Fourth Array
 

I'm using a Sumproduct formula (see below) that whilst it returns zero, the
3rd Array when view by pressing the = sign on the edit bar reads the account
numbers that match the criteria eg. ["A123";"A345","A678"}. What I now need
to do is use the returned account numbers to look up another table for a
debt figure.

Some help is required therefore to add a 4th or 5th Array.

=SUMPRODUCT(--(sales!E2:E300<=15),--(Sales!E2:E300),(Sales"A2:A300))

Thanks, Rob

Sumproduct Fourth Array
 

Nel post
*Rob* ha scritto:

I'm using a Sumproduct formula (see below) that whilst it returns
zero, the 3rd Array when view by pressing the = sign on the edit bar
reads the account numbers that match the criteria eg.
["A123";"A345","A678"}. What I now need to do is use the returned
account numbers to look up another table for a debt figure.

Some help is required therefore to add a 4th or 5th Array.

=SUMPRODUCT(--(sales!E2:E300<=15),--(Sales!E2:E300),(Sales"A2:A300))

Thanks, Rob


Hi Rob,

I think it could be simpler if you could upload an example file to
www.rapidshare.de

Anyway, I think you could find very interesting this article about
SUMPRODUCT function by Bob Phillips:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Sumproduct Fourth Array
 

Franz,

Not sure how to upload to the web site you suggest, will post a clearer
message later in new thread.

Regards, Rob

"Franz Verga" wrote in message
...
Nel post
*Rob* ha scritto:

I'm using a Sumproduct formula (see below) that whilst it returns
zero, the 3rd Array when view by pressing the = sign on the edit bar
reads the account numbers that match the criteria eg.
["A123";"A345","A678"}. What I now need to do is use the returned
account numbers to look up another table for a debt figure.

Some help is required therefore to add a 4th or 5th Array.

=SUMPRODUCT(--(sales!E2:E300<=15),--(Sales!E2:E300),(Sales"A2:A300))

Thanks, Rob


Hi Rob,

I think it could be simpler if you could upload an example file to
www.rapidshare.de

Anyway, I think you could find very interesting this article about
SUMPRODUCT function by Bob Phillips:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy