Sum Amount if two conditions are met

[Guest]

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

 

[PCLIVE]

One way:

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

HTH,
Paul

 

[Roger Govier]

Hi Gary

One way
=SUMPRODUCT(($A$1:$A$100="condition1")*($B$1:$B$100="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)

 

[Guest]

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