Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF Not | Excel Discussion (Misc queries) | |||
SUMIF Help | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |