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.

"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

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

Hi,
try

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

change range to fit your needs

"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

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