#1: Make sure the formula refers to the correct range of values to be totaled.

#2: Check Tools | Options and on the [Calculation] sheet and make sure that
"Automatic" calculation is selected.

"JL" wrote:

How do I get the row of numbers to add up to a total for the total box on an
expense statement?

It won't let you put a number in that box it says Excel has an equation and
figures it out by itself...But it never does?