Why does #NA appear in the total cell of a spread calculation?
Possible reason
When you create a formula for spreading totals using SPREAD, its target cells must be contained in the same sheet as the cells you use to define the spread.
Solution
For your spread formula, define the range for the spread and the range that defines the weighting in the same schedule.