Sumproduct Not Working

[carl]

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.

 

[Toppers]

Try:

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

"," instead of ";"

 

[carl]

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

 

[Toppers]

Irrespective of the "," it worked for me.

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

 

[Toppers]

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.

 

[Marcelo]

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: