| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with sumproduct & dynamic ranges | Excel Worksheet Functions | |||
| Need help with sumproduct and dynamic ranges | Excel Worksheet Functions | |||
| Sumproduct w/date criteria not working | Excel Worksheet Functions | |||
| SUMPRODUCT and format problems (2) | Excel Discussion (Misc queries) | |||
| Sumproduct - multiple criteria in Column A | Excel Worksheet Functions | |||
Linear Mode
