| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUBTOTAL QUERY
Hi All,
Can some help. I am using Excel 2007 I have 3 columns A B C Invoice Amount Sub Total D1000 50.00 D1000 1250.00 D1200 5000.00 D1200 1250.00 D1300 750.00 D1300 999.90 My question is this - how can I using the SUBTOTAL function in Excel,get it to subtotal the total value for each item in Col A and put the subtotal of these occurences in Column C. eg. in Column C for D1000 = 1300.00, D1200 = 6250.00 etc. I have tried every way but I can only get excel to put the subtotal amount in Col B after the end of each occurence of the totalled invoice numbers.Can anyone assist? Many thanks FinanceGuru -- Wales - the land of fire breathing dragons and rugby playing wizards. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro excel subtotal in subtotal | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
| copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Threaded Mode
