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

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

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