Sum Amount if two conditions are met

G

Gary

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
 
P

PCLIVE

One way:

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

HTH,
Paul
 
R

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)
 
E

Elkar

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
 
Top