| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with SUMPRODUCT
I admit I do not fully understand SUMPRODUCT; I am trying to follow the
variious samples I have found. Data: Whs Reasons Returns 1 1 2 10 DF 1 1 2 1 I want to sum the number of Returns when Whs=1 and Reasons=1, where Whs, Reasons and Returns are all named ranges. I have "=SUMPRODUCT((Whs=1)*AND(Reasons=1)*(Returns)) but the result is 0 rahter than 2. Any help would be greatly appreciated. Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with SUMPRODUCT
=SUMPRODUCT((Whs=1),(Reasons=1),(Returns))
-- If this post helps click Yes --------------- Jacob Skaria "Alex Mackenzie" wrote: I admit I do not fully understand SUMPRODUCT; I am trying to follow the variious samples I have found. Data: Whs Reasons Returns 1 1 2 10 DF 1 1 2 1 I want to sum the number of Returns when Whs=1 and Reasons=1, where Whs, Reasons and Returns are all named ranges. I have "=SUMPRODUCT((Whs=1)*AND(Reasons=1)*(Returns)) but the result is 0 rahter than 2. Any help would be greatly appreciated. Thank you. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with SUMPRODUCT
=SUMPRODUCT(--(Whs=1),--(Reasons=1),(Returns))
eg =SUMPRODUCT(--(A2:A6=D2),--(B2:B6=D3),(C2:C6)) -- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: =SUMPRODUCT((Whs=1),(Reasons=1),(Returns)) -- If this post helps click Yes --------------- Jacob Skaria "Alex Mackenzie" wrote: I admit I do not fully understand SUMPRODUCT; I am trying to follow the variious samples I have found. Data: Whs Reasons Returns 1 1 2 10 DF 1 1 2 1 I want to sum the number of Returns when Whs=1 and Reasons=1, where Whs, Reasons and Returns are all named ranges. I have "=SUMPRODUCT((Whs=1)*AND(Reasons=1)*(Returns)) but the result is 0 rahter than 2. Any help would be greatly appreciated. Thank you. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with SUMPRODUCT
Used the formula as written, results in #VALUE!.
I believe my ranges are okay, since I have summed the returns based on reasons only; I want to breakdown the results further by Whs. Thank you. "Jacob Skaria" wrote: =SUMPRODUCT((Whs=1),(Reasons=1),(Returns)) -- If this post helps click Yes --------------- Jacob Skaria "Alex Mackenzie" wrote: I admit I do not fully understand SUMPRODUCT; I am trying to follow the variious samples I have found. Data: Whs Reasons Returns 1 1 2 10 DF 1 1 2 1 I want to sum the number of Returns when Whs=1 and Reasons=1, where Whs, Reasons and Returns are all named ranges. I have "=SUMPRODUCT((Whs=1)*AND(Reasons=1)*(Returns)) but the result is 0 rahter than 2. Any help would be greatly appreciated. Thank you. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with SUMPRODUCT
try this
=SUMPRODUCT(--(Whs=1),--(Reasons=1),C2:C4) -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Alex Mackenzie" wrote: I admit I do not fully understand SUMPRODUCT; I am trying to follow the variious samples I have found. Data: Whs Reasons Returns 1 1 2 10 DF 1 1 2 1 I want to sum the number of Returns when Whs=1 and Reasons=1, where Whs, Reasons and Returns are all named ranges. I have "=SUMPRODUCT((Whs=1)*AND(Reasons=1)*(Returns)) but the result is 0 rahter than 2. Any help would be greatly appreciated. Thank you. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with SUMPRODUCT
Sorry, same result. The change was 2 hyphens correct?
Does the fact that I am stuck with Excel 2000 have anything to do with it? "Jacob Skaria" wrote: =SUMPRODUCT(--(Whs=1),--(Reasons=1),(Returns)) eg =SUMPRODUCT(--(A2:A6=D2),--(B2:B6=D3),(C2:C6)) -- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: =SUMPRODUCT((Whs=1),(Reasons=1),(Returns)) -- If this post helps click Yes --------------- Jacob Skaria "Alex Mackenzie" wrote: I admit I do not fully understand SUMPRODUCT; I am trying to follow the variious samples I have found. Data: Whs Reasons Returns 1 1 2 10 DF 1 1 2 1 I want to sum the number of Returns when Whs=1 and Reasons=1, where Whs, Reasons and Returns are all named ranges. I have "=SUMPRODUCT((Whs=1)*AND(Reasons=1)*(Returns)) but the result is 0 rahter than 2. Any help would be greatly appreciated. Thank you. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with SUMPRODUCT
Try without the named ranges and then post your formula if it doesnt.
-- If this post helps click Yes --------------- Jacob Skaria "Alex Mackenzie" wrote: Sorry, same result. The change was 2 hyphens correct? Does the fact that I am stuck with Excel 2000 have anything to do with it? "Jacob Skaria" wrote: =SUMPRODUCT(--(Whs=1),--(Reasons=1),(Returns)) eg =SUMPRODUCT(--(A2:A6=D2),--(B2:B6=D3),(C2:C6)) -- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: =SUMPRODUCT((Whs=1),(Reasons=1),(Returns)) -- If this post helps click Yes --------------- Jacob Skaria "Alex Mackenzie" wrote: I admit I do not fully understand SUMPRODUCT; I am trying to follow the variious samples I have found. Data: Whs Reasons Returns 1 1 2 10 DF 1 1 2 1 I want to sum the number of Returns when Whs=1 and Reasons=1, where Whs, Reasons and Returns are all named ranges. I have "=SUMPRODUCT((Whs=1)*AND(Reasons=1)*(Returns)) but the result is 0 rahter than 2. Any help would be greatly appreciated. Thank you. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with SUMPRODUCT
Are all the ranges the same size (and single columns)?
And are all the ranges less than a whole column? Are there any errors in any of the ranges? If this doesn't help, what are the addresses for each of the ranges? Alex Mackenzie wrote: Sorry, same result. The change was 2 hyphens correct? Does the fact that I am stuck with Excel 2000 have anything to do with it? "Jacob Skaria" wrote: =SUMPRODUCT(--(Whs=1),--(Reasons=1),(Returns)) eg =SUMPRODUCT(--(A2:A6=D2),--(B2:B6=D3),(C2:C6)) -- If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: =SUMPRODUCT((Whs=1),(Reasons=1),(Returns)) -- If this post helps click Yes --------------- Jacob Skaria "Alex Mackenzie" wrote: I admit I do not fully understand SUMPRODUCT; I am trying to follow the variious samples I have found. Data: Whs Reasons Returns 1 1 2 10 DF 1 1 2 1 I want to sum the number of Returns when Whs=1 and Reasons=1, where Whs, Reasons and Returns are all named ranges. I have "=SUMPRODUCT((Whs=1)*AND(Reasons=1)*(Returns)) but the result is 0 rahter than 2. Any help would be greatly appreciated. Thank you. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
| SumProduct? | Excel Discussion (Misc queries) | |||
| sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
| hlp with sumproduct! | Excel Worksheet Functions | |||
| sumproduct | Excel Worksheet Functions | |||
Linear Mode
