Using Formulas in a Template...

D

Dave Harris

I am trying to create a form that uses a simple calculation that totals up
currency items in a column of a table.....

My fields are called Total1, Total2, Total3 etc.

When I enter the formula as SUM(Total1), it displays the amount correctly,
but what I want is to add all the Total1, Total2, Total3 together to be
displayed as one big total....

Can this be done? Does anyone know the correct syntax for this?

Have tried the following :

SUM(Total1;Total2;Total3)
SUM(Total1)+(Total2)+(Total3)
SUM(Total1Total2Total3)
I could go on.....

Thanks!

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grand Totals on Forms 1
#Error when no items are in stock. I want to display 0 instead 8
TO TOM OR KEN: macro to calculate selected range 3
Summing Null Fields 3
If Statement 1
Subtable that automatically expands with totals on the top 0
Date Time Group Math 3
Excel Progress Bar 2

Top