SUM formula help

[gomes.]

In the screen shot, I calculated the total cost by multiplying cost per lesson by no. of lessons using the formula below:

=[Number of lessons attended]*[Cost Per Lesson]

What formula would I use to make the program add up all the total costs? so in this case 265+378. and then display it at the bottom of the screen.



Thanks!

 

[pbaldy]

Try

=Sum([Number of lessons attended]*[Cost Per Lesson])

 

[gomes.]

hi thanks, tried it. gave me an error (#error).

any ideas? cheers!

 

[pbaldy]

Where did you have it? It would have to be the report footer, not the page footer.

 

[gomes.]

Thanks Paul, it seems I put it in the page footer which messed it up! Its working, cheers.

 

[pbaldy]

It would be nice if these kinds of things worked in the page footer, but they don't. Glad we got it sorted out.

 

[gomes.]

haha yea.!!!