Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Embedding a Sumif in a sumif C.Pflugrath Excel Worksheet Functions 5 August 31st 05 07:31 PM
nested sumif or sumif with two criteria dshigley Excel Worksheet Functions 5 April 5th 05 03:34 AM
SUMIF Not vanjohnson Excel Discussion (Misc queries) 1 March 4th 05 08:42 PM
SUMIF Help JC Excel Discussion (Misc queries) 1 February 21st 05 05:17 PM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function Oscar Excel Worksheet Functions 2 January 11th 05 11:01 PM


All times are GMT +1. The time now is 09:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"