Sumproduct Not Working

Thank you for helping with my question from yesterday. The formula I am using
is:

=SUMPRODUCT((K5:K55={"BOX549";"BOX919"})*(L5:L55)) - it returns #N/A

The Data is in ColK and ColL - looks like this:

BOX549 69460
BOX919 49746
BOX017 37297
BOX980 22848
BOX910 19862

Any thoughts on why the formula does not work ?

Thank you in advance.

Try:

=SUMPRODUCT((K5:K55={"BOX549","BOX919"})*(L5:L55))

"," instead of ";"

"carl" wrote:

> Thank you for helping with my question from yesterday. The formula I am using
> is:
>
> =SUMPRODUCT((K5:K55={"BOX549";"BOX919"})*(L5:L55)) - it returns #N/A
>
> The Data is in ColK and ColL - looks like this:
>
> BOX549 69460
> BOX919 49746
> BOX017 37297
> BOX980 22848
> BOX910 19862
>
> Any thoughts on why the formula does not work ?
>
> Thank you in advance.
>

My excel uses ";" versus "," so that will not help.

"Toppers" wrote:

> Try:
>
> =SUMPRODUCT((K5:K55={"BOX549","BOX919"})*(L5:L55))
>
> "," instead of ";"
>
> "carl" wrote:
>
> > Thank you for helping with my question from yesterday. The formula I am using
> > is:
> >
> > =SUMPRODUCT((K5:K55={"BOX549";"BOX919"})*(L5:L55)) - it returns #N/A
> >
> > The Data is in ColK and ColL - looks like this:
> >
> > BOX549 69460
> > BOX919 49746
> > BOX017 37297
> > BOX980 22848
> > BOX910 19862
> >
> > Any thoughts on why the formula does not work ?
> >
> > Thank you in advance.
> >

Irrespective of the "," it worked for me.

"carl" wrote:

> My excel uses ";" versus "," so that will not help.
>
> "Toppers" wrote:
>
> > Try:
> >
> > =SUMPRODUCT((K5:K55={"BOX549","BOX919"})*(L5:L55))
> >
> > "," instead of ";"
> >
> > "carl" wrote:
> >
> > > Thank you for helping with my question from yesterday. The formula I am using
> > > is:
> > >
> > > =SUMPRODUCT((K5:K55={"BOX549";"BOX919"})*(L5:L55)) - it returns #N/A
> > >
> > > The Data is in ColK and ColL - looks like this:
> > >
> > > BOX549 69460
> > > BOX919 49746
> > > BOX017 37297
> > > BOX980 22848
> > > BOX910 19862
> > >
> > > Any thoughts on why the formula does not work ?
> > >
> > > Thank you in advance.
> > >

Did you try it with the ","?

If not, please do as I note in response to your previous posting all
respondents used the ", " as delimeter; it has a speciall meaning with arrays
to diiferentiate between row and column arrays.

"Toppers" wrote:

> Irrespective of the "," it worked for me.
>
> "carl" wrote:
>
> > My excel uses ";" versus "," so that will not help.
> >
> > "Toppers" wrote:
> >
> > > Try:
> > >
> > > =SUMPRODUCT((K5:K55={"BOX549","BOX919"})*(L5:L55))
> > >
> > > "," instead of ";"
> > >
> > > "carl" wrote:
> > >
> > > > Thank you for helping with my question from yesterday. The formula I am using
> > > > is:
> > > >
> > > > =SUMPRODUCT((K5:K55={"BOX549";"BOX919"})*(L5:L55)) - it returns #N/A
> > > >
> > > > The Data is in ColK and ColL - looks like this:
> > > >
> > > > BOX549 69460
> > > > BOX919 49746
> > > > BOX017 37297
> > > > BOX980 22848
> > > > BOX910 19862
> > > >
> > > > Any thoughts on why the formula does not work ?
> > > >
> > > > Thank you in advance.
> > > >

Hi,

in Brazilian Portuguese we also use ";" but inside brakets {} use "."

==SUMPRODUCT((K5:K55={"BOX549"."BOX919"})*(L5:L55))


hth
regards from Brazil
Marcelo


"carl" escreveu:

> My excel uses ";" versus "," so that will not help.
>
> "Toppers" wrote:
>
> > Try:
> >
> > =SUMPRODUCT((K5:K55={"BOX549","BOX919"})*(L5:L55))
> >
> > "," instead of ";"
> >
> > "carl" wrote:
> >
> > > Thank you for helping with my question from yesterday. The formula I am using
> > > is:
> > >
> > > =SUMPRODUCT((K5:K55={"BOX549";"BOX919"})*(L5:L55)) - it returns #N/A
> > >
> > > The Data is in ColK and ColL - looks like this:
> > >
> > > BOX549 69460
> > > BOX919 49746
> > > BOX017 37297
> > > BOX980 22848
> > > BOX910 19862
> > >
> > > Any thoughts on why the formula does not work ?
> > >
> > > Thank you in advance.
> > >