Running total on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top