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