Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
running total.....hepl!!!
Is it possible to keep a running total on individual items on a list. I have
a table which on column 'A' lists items (which can be added to), columns B,C and D are headed..... Items supplied, items sold and stock remaining. Data entered would be in any order so the the running total would have to deal with that. Anybody any ideas???? -- ASU |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
running total.....hepl!!!
Filtering your data can work for this problem. e.g. filter the items
required in col. A then, on an otherwise unused row you could put a formula covering the required range i.e. =SUBTOTAL(9,B2:B10) and copy this to col. C & D. As you add more data, insert extra rows so that the range in the SUBTOTAL formula changes. I've no doubt there will be other solutions posted. "ASU" wrote: Is it possible to keep a running total on individual items on a list. I have a table which on column 'A' lists items (which can be added to), columns B,C and D are headed..... Items supplied, items sold and stock remaining. Data entered would be in any order so the the running total would have to deal with that. Anybody any ideas???? -- ASU |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
running total.....hepl!!!
Thanks very much for that. Yes I'v tried that and it works ok, but
unfortunately not quite what I was looking for. I was looking for a vb code or formula that filtered automatically without having a dropdown box. I'm sounding abit fussy!! sorry for that! -- ASU "bigwheel" wrote: Filtering your data can work for this problem. e.g. filter the items required in col. A then, on an otherwise unused row you could put a formula covering the required range i.e. =SUBTOTAL(9,B2:B10) and copy this to col. C & D. As you add more data, insert extra rows so that the range in the SUBTOTAL formula changes. I've no doubt there will be other solutions posted. "ASU" wrote: Is it possible to keep a running total on individual items on a list. I have a table which on column 'A' lists items (which can be added to), columns B,C and D are headed..... Items supplied, items sold and stock remaining. Data entered would be in any order so the the running total would have to deal with that. Anybody any ideas???? -- ASU |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running total.... | Excel Discussion (Misc queries) | |||
running total by date (not sorted by date though...) | Excel Worksheet Functions | |||
Running total at bottom of column? | Excel Discussion (Misc queries) | |||
Running total w/2 columns - Excel | Excel Worksheet Functions | |||
how do I keep a running total of my bills? | Charts and Charting in Excel |