Multi-condition SUMIF

  • Thread starter Thread starter Manuel
  • Start date Start date
M

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
 
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.
 
If your columns are A, B, and C

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

Adjust the ranges to suit.
 
Hi,
try

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

change range to fit your needs
 
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
 
Back
Top