Formula for using SUM feature is fill in table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TJ - 13 Jan 2006 16:49 GMT

I have two columns in my form. When the staff inputs their information into
the forms, I want each column to be added. B2:B10 and C2:C10. How can I
accomplish this with a fill in form?

Thanks in advance

Reply to this Message

Greg - 13 Jan 2006 17:36 GMT

Double click each input field and check "Calculate of exit"

Enter the formulat

{=Sum(B2:B10)} in your table where you want the data to appear.

Note: the field code braces { } are entered with CTRL+F9

Reply to this Message