J
jjohnsonofduluthMN
Hello,
I am trying to sum one column but need to pull critera from two different
columns. Does anybody have any suggestions?
Here's an example.
Coulmn A has property codes 33-40-41 etc..., coulmn B has the dollar amount
and coulmn C has if it is an F=fixed asset or N=non fixed asset. I need to
sum the dollar amounts in column B only if coulmn A = 33 and coulmn C=F (see
below) My total should be $1300.00. Is there a way without using a pivot
table?
A B C
33 50.55 N
40 100.25 F
40 200.00 N
33 800.00 F
33 500.00 F
I am trying to sum one column but need to pull critera from two different
columns. Does anybody have any suggestions?
Here's an example.
Coulmn A has property codes 33-40-41 etc..., coulmn B has the dollar amount
and coulmn C has if it is an F=fixed asset or N=non fixed asset. I need to
sum the dollar amounts in column B only if coulmn A = 33 and coulmn C=F (see
below) My total should be $1300.00. Is there a way without using a pivot
table?
A B C
33 50.55 N
40 100.25 F
40 200.00 N
33 800.00 F
33 500.00 F