Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running total on form
I need to create a form for entering rental information for a community
center and I need a field that will keep a running total of the cost of rentals. I'm not sure how to do this, or if you can do this in Xcel, since the number of entries will be variable. I know I can do it in Access, but they don't have Access at the center and the Access that I have won't let you create a stand alone program. Can this be done in Xcel. Thanks, RandyM |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running total on form
sure, wherever you want the total, i suggest out to the side, put a formula
something like this: =Sum(A1:A1000) this will give you a sum of everything between cell A1 and A1000, change as needed and if there is no data it won't count it so do A1 to A60000 if you want and you will get the same results. -- -John Please rate when your question is answered to help us and others know what is helpful. "WCDoan" wrote: I need to create a form for entering rental information for a community center and I need a field that will keep a running total of the cost of rentals. I'm not sure how to do this, or if you can do this in Xcel, since the number of entries will be variable. I know I can do it in Access, but they don't have Access at the center and the Access that I have won't let you create a stand alone program. Can this be done in Xcel. Thanks, RandyM |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Running total on form
Thanks John, that sounds like that should do it.
RandyM "John Bundy" wrote: sure, wherever you want the total, i suggest out to the side, put a formula something like this: =Sum(A1:A1000) this will give you a sum of everything between cell A1 and A1000, change as needed and if there is no data it won't count it so do A1 to A60000 if you want and you will get the same results. -- -John Please rate when your question is answered to help us and others know what is helpful. "WCDoan" wrote: I need to create a form for entering rental information for a community center and I need a field that will keep a running total of the cost of rentals. I'm not sure how to do this, or if you can do this in Xcel, since the number of entries will be variable. I know I can do it in Access, but they don't have Access at the center and the Access that I have won't let you create a stand alone program. Can this be done in Xcel. Thanks, RandyM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
Running Total - on a form that clears - No Accumulator! | Excel Discussion (Misc queries) | |||
Keep a running total while using a clearable form | Excel Discussion (Misc queries) | |||
Running Total | Excel Worksheet Functions |