Sum Amount if two conditions are met
 

I am having trouble with a formula. I am looking to sum dollar amounts in
column C when conditions for columns A & B are met.

Can someone please assist?

Thanks,

Gary

Sum Amount if two conditions are met
 

One way:

=SUMPRODUCT(--(A1:A10="condition1"),--(B1:B10="Condition2"),C1:C10)

HTH,
Paul

"Gary" wrote in message
...
I am having trouble with a formula. I am looking to sum dollar amounts in
column C when conditions for columns A & B are met.

Can someone please assist?

Thanks,

Gary

Sum Amount if two conditions are met
 

Hi Gary

One way
=SUMPRODUCT(($A$1:$A$100="condition1")*($B$1:$B$10 0="condition2")*$C$1:$C$100)

Change ranges to suit, but ensure they are of equal length (you can't
use whole columns in Sumproduct).
If your conditions are numeric, don't enclose them in quotes. If they
are text, then use quotes.
Equally you put your conditions in cells and refer to the cells

=SUMPRODUCT(($A$1:$A$100=$F$1)*($B$1:$B$100=$G$1)* $C$1:$C$100)
--
Regards

Roger Govier


"Gary" wrote in message
...
I am having trouble with a formula. I am looking to sum dollar amounts
in
column C when conditions for columns A & B are met.

Can someone please assist?

Thanks,

Gary

Sum Amount if two conditions are met
 

The SUMPRODUCT function would probably work best for you. Something like:

=SUMPRODUCT(--(A1:A100="condition1"),--(B1:B100="condition2"),C1:C100)

This will check for "condition1" in column A and "condition2" in column B.
If both conditions return as TRUE, then column C will be added.

HTH,
Elkar


"Gary" wrote:

I am having trouble with a formula. I am looking to sum dollar amounts in
column C when conditions for columns A & B are met.

Can someone please assist?

Thanks,

Gary