First, there is no value is using the SUM function in your formula. Just use
Formula:
=G2*H2
The SUM formula is not what's causing your problem, though. I'm not following your description of what works fine; there is no value 130.58 anywhere so I don't know what you changed. And it shouldn't matter anyway.
Here is what I think your problem is. All your formulas in 'Week 1'!F7:F16 refer to data in column G (last argument to SUMPRODUCT) but the formula in F6 (the one that is giving you #N/A) is referring to column I. Is that on purpose? If you use the same formula in F6 as in the cells below it, there is no error.
Bookmarks