# Thread: Sum of more than two fields in a form

1. Registered User
Join Date
May 2007
Posts
1

## Unanswered: Sum of more than two fields in a form

I have a form with several fields I want to calculate to another field (Cash). I can use this =Sum([100])+([50]), and it works but for more than two fields it will not calculate right. I also have a fields for 20,10,5,2,1 and when I add them on to the =Sum calculation, it just does not work. I want all those to claculate into the cash field. I know I should have paid more attention in Algebra.

Dave

2. www.gvee.co.uk
Join Date
Jan 2007
Location
UK
Posts
11,445
Code:
`=Sum([100])+([50])`
This will sum the value 100 (=100) and then add 50.
You need to look into how the Sum() function works, I think you'll see what's wrong fairly quick, but if not, feel free to come back and ask!

3. Registered User
Join Date
Feb 2004
Location
Wales
Posts
343
=Sum([100]+[50]+[20]+[10]+[5])

If you are using this as a cash counting operation be aware of HOW you're entering the values. it will require the cash value NOT the count of how many 50's there are ie 10 - 50s' will be 500 and not 10 unless you are multiplying by the cash type

gareth

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•