sum product if
 

i need a formula to sum a product of the info in two columns based on meeting
the if criteria. i have tried to use a combination of the SUMPRODUCT AND
SUMIF without success. For example
Column 1 Column 2 Column 3
State Hours Rate
PA 2 $50
PA 1 $10
NJ 4 $20
MD 3 $40
NJ 1 $10
PA 2 $10

I would like a formula to put in a cell to automatically look down column 1
("state") and sum the products of the "hours" and "rates" for a particular
state. PA: 2*$50 + 1*$10 + 2*$10 = $130.

sum product if
 

With data in A1:C7, put this function in cell E2:
=SUMPRODUCT(--(A2:A7="PA"),(B2:B7)*(C2:C7))

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"r2rcode" wrote:

i need a formula to sum a product of the info in two columns based on meeting
the if criteria. i have tried to use a combination of the SUMPRODUCT AND
SUMIF without success. For example
Column 1 Column 2 Column 3
State Hours Rate
PA 2 $50
PA 1 $10
NJ 4 $20
MD 3 $40
NJ 1 $10
PA 2 $10

I would like a formula to put in a cell to automatically look down column 1
("state") and sum the products of the "hours" and "rates" for a particular
state. PA: 2*$50 + 1*$10 + 2*$10 = $130.

sum product if
 

perfect... thanks for your help

"ryguy7272" wrote:

With data in A1:C7, put this function in cell E2:
=SUMPRODUCT(--(A2:A7="PA"),(B2:B7)*(C2:C7))

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"r2rcode" wrote:

i need a formula to sum a product of the info in two columns based on meeting
the if criteria. i have tried to use a combination of the SUMPRODUCT AND
SUMIF without success. For example
Column 1 Column 2 Column 3
State Hours Rate
PA 2 $50
PA 1 $10
NJ 4 $20
MD 3 $40
NJ 1 $10
PA 2 $10

I would like a formula to put in a cell to automatically look down column 1
("state") and sum the products of the "hours" and "rates" for a particular
state. PA: 2*$50 + 1*$10 + 2*$10 = $130.

Hi,

How would I include another condition into this formula?

Essentially, I want to include (B:B="<Total") into this formula:

=SUMPRODUCT(--(A:A=A1),(C:C)*(D:D))

I tried putting in an AND statement, but that didn't seem to work..

I hope this makes sense!