Average / Sum formulas

[Tracyann]

I have a spreadsheet that several formulas use average to get the total on various spreadsheets.

The final formula + those totals together to get the final total, but for some reason it is taking the average of the five totals that I want it to add up.

Is there any way of stopping it working at the average and just giving me the total

Thanks