Thread: sumif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
oldLearner57 oldLearner57 is offline
external usenet poster
 
Posts: 119
Default sumif

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