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.

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.

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.

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.