Multi-condition SUMIF
If your columns are A, B, and C
=SUMPRODUCT(--(A1:A100="A"),--(B1:B100="X"),C1:C100)
Adjust the ranges to suit.
--
David Biddulph
"Manuel" wrote in message
...
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
|