Multi-condition SUMIF

[Manuel]

Here's my issue:

I need to sum a column only if 2 conditions are true in two other columns.
Here's the set up:

Con1 Con2 $
A X 100
A 200
B 300
B X 400


So, what I'd like to do is sum column $ when the value in the Con1 column =
A AND the value in the Con2 column = X.

I know that I can just create a composite column, but I was trying to avoid
doing that.

Any suggestions?

Thanks,

Manuel

 

[Brad Autry]

If I understand your post right, you could do something along the lines of:

=IF(AND(A2="A",B2="X"),SUM(whatever),"")

I wasn't sure what you wanted to sum, so you'd have to fill in the whatever
part.

 

[David Biddulph]

If your columns are A, B, and C

=SUMPRODUCT(--(A1:A100="A"),--(B1:B100="X"),C1:C100)

Adjust the ranges to suit.

 

[Eduardo]

Hi,
try

=SUMPRODUCT(($A$1:$A$17="A")*($B$1:$B$17="X")*I1:I17)

change range to fit your needs

 

[Mohamed]

you can use database functions

at any part of sheet copy the header of your table and put the criteria you
need for each condition like:

N M O
1 con1 con2 $
2 A X

then type the formula

=DSUM(A1:C5,3,N1:O2)

A1:C5 replace it with your range
3 is the number for the column you want to sum
N1:O2 range with the criteria you need