Multi-condition SUMIF
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
"Manuel" wrote:
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
|