Sum Amount if two conditions are met

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
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
 
Back
Top