Adding up numbers

[lous]

I have a spreadsheet that has many fields that a person can type a number into. Upon moving off that field, I would like a "Total" field to automatically add up all these fields (running total) and store it in the database.

How do I do this? I've tried a few ways and none of them have worked, so hopefully you can help.

 

[andrew299]

Does

=SUM(H6+E6+I6)

in the 'total cell' not work?
obviously put your own range in

Andrew299

 

[lous]

Well, I see I've messed this post up good. I meant to say I have an Access database that needs this done.

Each field has a number and a Total field should be keeping track of it as they are entered.

Sorry about that.

 

[lous]

Anyone, anyone??

 

[Nikita6003]

Well you can't do this straight in a table but you *could* create a userform instead, where you:
1. add the fields that need summing
2. add a textfield where you sum the other fields
3. store this in your db when the user closes the form or clicks a save button

mightn't that do?
If not, please elaborate on what you want/need to do here ;-)

Cheers
Nikki

 

[RivetHed]

I'm assuming this is a load of textboxes on a form id so does =[Text1]+[Text2] etc do? Also why do you want to store the total in the database? if all the entered values are stored the total can be calculated at any time.