Question with a formula
 

Hi there, I am trying to create a formula for the data below that would add
volumes in column C that coorespond to the "Wash" and "Blend" (not
Blend50/50) in Column B seperately for the categories Concrete and Rock. Is
there a formula that could do this for me?

A B C
1 concrete Acid 1,002.00
2 concrete Wash 7,350.00
3 concrete Blend 9,996.00
4 concrete Blend50/50 96,178.00
5 rock Acid 500
6 rock Wash 7,140.00
7 rock Blend 10,351.00
8 rock Blend50/50 108,904.00

Thanks!

Question with a formula
 

Do you mean you want to sum column C if column B is "Wash" OR "Blend"?
=SUMIF(B1:B100,"wash",C1:C100)+SUMIF(B1:B100,"blen d",C1:C100)

or if you wanted separate formulas for those two criteria, then just break
the formula apart.

HTH,
Paul


--

"CrisT" wrote in message
...
Hi there, I am trying to create a formula for the data below that would
add
volumes in column C that coorespond to the "Wash" and "Blend" (not
Blend50/50) in Column B seperately for the categories Concrete and Rock.
Is
there a formula that could do this for me?

A B C
1 concrete Acid 1,002.00
2 concrete Wash 7,350.00
3 concrete Blend 9,996.00
4 concrete Blend50/50 96,178.00
5 rock Acid 500
6 rock Wash 7,140.00
7 rock Blend 10,351.00
8 rock Blend50/50 108,904.00

Thanks!

Question with a formula
 

Thank you Paul, how do I have it do this for just the figures that contain
Concrete or Rock, I actually have several other names in column A and need to
add the Wash and Blend for each name seperately from each other.

"PCLIVE" wrote:

Do you mean you want to sum column C if column B is "Wash" OR "Blend"?
=SUMIF(B1:B100,"wash",C1:C100)+SUMIF(B1:B100,"blen d",C1:C100)

or if you wanted separate formulas for those two criteria, then just break
the formula apart.

HTH,
Paul


--

"CrisT" wrote in message
...
Hi there, I am trying to create a formula for the data below that would
add
volumes in column C that coorespond to the "Wash" and "Blend" (not
Blend50/50) in Column B seperately for the categories Concrete and Rock.
Is
there a formula that could do this for me?

A B C
1 concrete Acid 1,002.00
2 concrete Wash 7,350.00
3 concrete Blend 9,996.00
4 concrete Blend50/50 96,178.00
5 rock Acid 500
6 rock Wash 7,140.00
7 rock Blend 10,351.00
8 rock Blend50/50 108,904.00

Thanks!

Question with a formula
 

That will use a different formula. There may be a different way of doing
it, but here's one way.

=SUMPRODUCT(--(A1:A100="Concrete"),--(B1:B100="Wash"),C1:C100)+SUMPRODUCT(--(A1:A100="Concrete"),--(B1:B100="Blend"),C1:C100)

If you have your criteria in a cells, (ex. X1="Concrete" Y1="Wash"
Z1="Blend"), then:

=SUMPRODUCT(--(A1:A100=X1),--(B1:B100=Y1),C1:C100)+SUMPRODUCT(--(A1:A100=X1),--(B1:B100=Z1),C1:C100)

Regards,
Paul


--

"CrisT" wrote in message
...
Thank you Paul, how do I have it do this for just the figures that contain
Concrete or Rock, I actually have several other names in column A and need
to
add the Wash and Blend for each name seperately from each other.

"PCLIVE" wrote:

Do you mean you want to sum column C if column B is "Wash" OR "Blend"?
=SUMIF(B1:B100,"wash",C1:C100)+SUMIF(B1:B100,"blen d",C1:C100)

or if you wanted separate formulas for those two criteria, then just
break
the formula apart.

HTH,
Paul


--

"CrisT" wrote in message
...
Hi there, I am trying to create a formula for the data below that would
add
volumes in column C that coorespond to the "Wash" and "Blend" (not
Blend50/50) in Column B seperately for the categories Concrete and
Rock.
Is
there a formula that could do this for me?

A B C
1 concrete Acid 1,002.00
2 concrete Wash 7,350.00
3 concrete Blend 9,996.00
4 concrete Blend50/50 96,178.00
5 rock Acid 500
6 rock Wash 7,140.00
7 rock Blend 10,351.00
8 rock Blend50/50 108,904.00

Thanks!