O
oldLearner57
hi community
can community assist me to solve this.....
A B C E
1 ITTCHG ADV 5.00
2 MER ADV 3.00
3 TRFCPU ADV 5.00
4 MER ADV 5.00
5 BILL ATP 12.00
6 CHQ 5.00
7 QCDM CHQ 6.00
8 CHQ 5.00
9 QCDM CHQ 2.00
10 21334 CHQ 10.00
what i want to do with the above range are these format:
e.g 1
If Col B = "CHQ" & Col = ""
sum(E?:E?)
e.g 2
If Col B = "CHQ" & Col A = "QCDM"
sum(E?:E?)
and in this e.g 2
if Col = "CHQ"
sum(e.g1'sum' + e.g2'sum')
e.g 3
If Col B = "ADV" & Col A = "MER"
sum(E?:E?)
can the above to done ?
thanks community
oldLearner57
can community assist me to solve this.....
A B C E
1 ITTCHG ADV 5.00
2 MER ADV 3.00
3 TRFCPU ADV 5.00
4 MER ADV 5.00
5 BILL ATP 12.00
6 CHQ 5.00
7 QCDM CHQ 6.00
8 CHQ 5.00
9 QCDM CHQ 2.00
10 21334 CHQ 10.00
what i want to do with the above range are these format:
e.g 1
If Col B = "CHQ" & Col = ""
sum(E?:E?)
e.g 2
If Col B = "CHQ" & Col A = "QCDM"
sum(E?:E?)
and in this e.g 2
if Col = "CHQ"
sum(e.g1'sum' + e.g2'sum')
e.g 3
If Col B = "ADV" & Col A = "MER"
sum(E?:E?)
can the above to done ?
thanks community
oldLearner57