Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct in Excel 2003
Hello, I need help. I submitted this question before but for some reason, it
disappeared. I need to get a formula to do the following in Excel 2003 Col A Col B Col C R1 C1 = can have value of A, B or C R2 Jim 500 50% R3 Anne 100 100% R4 Jim 200 100% R5 Mary 200 50% I need to find the sumproduct if C1 = B and Col A = Jim. Sumproduct should equal to 250 + 200 = 450. In Excel 2007, I can do this - = SUMPRODUCT((A2:A5="Jim")*OR((C1="B"),(C1="C"))*B2: B5,C2:C5),0),0) How do I get this to be converted into Excel 2003? Any help would be much appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct in Excel 2003
Try
=SUMPRODUCT((A2:A5="Jim")*OR((C1="B"),(C1="C"))*B2 :B5,C2:C5) If this post helps click Yes --------------- Jacob Skaria "lisay" wrote: Hello, I need help. I submitted this question before but for some reason, it disappeared. I need to get a formula to do the following in Excel 2003 Col A Col B Col C R1 C1 = can have value of A, B or C R2 Jim 500 50% R3 Anne 100 100% R4 Jim 200 100% R5 Mary 200 50% I need to find the sumproduct if C1 = B and Col A = Jim. Sumproduct should equal to 250 + 200 = 450. In Excel 2007, I can do this - = SUMPRODUCT((A2:A5="Jim")*OR((C1="B"),(C1="C"))*B2: B5,C2:C5),0),0) How do I get this to be converted into Excel 2003? Any help would be much appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct in Excel 2003
"lisay" wrote:
I need to find the sumproduct if C1 = B and Col A = Jim. Sumproduct should equal to 250 + 200 = 450. In Excel 2007, I can do this - = SUMPRODUCT((A2:A5="Jim")*OR((C1="B"),(C1="C"))*B2: B5,C2:C5),0),0) =SUMPRODUCT((A2:A5="jim")*OR(C1={"b","c"}), B2:B5, C2:C5) Should work equally well in Excel 2003 and 2007. ----- original message ----- "lisay" wrote in message ... Hello, I need help. I submitted this question before but for some reason, it disappeared. I need to get a formula to do the following in Excel 2003 Col A Col B Col C R1 C1 = can have value of A, B or C R2 Jim 500 50% R3 Anne 100 100% R4 Jim 200 100% R5 Mary 200 50% I need to find the sumproduct if C1 = B and Col A = Jim. Sumproduct should equal to 250 + 200 = 450. In Excel 2007, I can do this - = SUMPRODUCT((A2:A5="Jim")*OR((C1="B"),(C1="C"))*B2: B5,C2:C5),0),0) How do I get this to be converted into Excel 2003? Any help would be much appreciated. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct in Excel 2003
This works! Thank you!
"Jacob Skaria" wrote: Try =SUMPRODUCT((A2:A5="Jim")*OR((C1="B"),(C1="C"))*B2 :B5,C2:C5) If this post helps click Yes --------------- Jacob Skaria "lisay" wrote: Hello, I need help. I submitted this question before but for some reason, it disappeared. I need to get a formula to do the following in Excel 2003 Col A Col B Col C R1 C1 = can have value of A, B or C R2 Jim 500 50% R3 Anne 100 100% R4 Jim 200 100% R5 Mary 200 50% I need to find the sumproduct if C1 = B and Col A = Jim. Sumproduct should equal to 250 + 200 = 450. In Excel 2007, I can do this - = SUMPRODUCT((A2:A5="Jim")*OR((C1="B"),(C1="C"))*B2: B5,C2:C5),0),0) How do I get this to be converted into Excel 2003? Any help would be much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct in Excel 2003 | Excel Worksheet Functions | |||
SUMPRODUCT FORMULA EXCEL 2003 | Excel Worksheet Functions | |||
Excel 2003 Multi Worksheet Sumproduct? | Excel Worksheet Functions | |||
Multi Worksheet Sumproduct Excel 2003 | Excel Discussion (Misc queries) | |||
XL 2003 & Sumproduct Question | Excel Discussion (Misc queries) |