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.

Sumproduct Not Working
 

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.

Sumproduct Not Working
 

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.

Sumproduct Not Working
 

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.

Sumproduct Not Working
 

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.

Sumproduct Not Working
 

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.