|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 15th, 2009, 07:26 PM
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
May 15th, 2009, 07:31 PM
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
May 15th, 2009, 07:38 PM
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
May 15th, 2009, 07:39 PM
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
May 15th, 2009, 07:43 PM
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
May 15th, 2009, 07:44 PM
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
May 15th, 2009, 07:48 PM
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
May 15th, 2009, 08:17 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
