Why does #VALUE appear in the total cell of a spread calculation?
Possible reason
The cells which make up the formula do not have the appropriate Excel format.
Solution
For each cell which makes up the formula for calculating the total, select the Number Excel format.