I have a simple =SUM formula, but need to see the value in that cell, not the formula.

Originally Posted by Jonmo1

To resolve, change the formula in Data Input H2 (and filled down) to
=IFERROR(VLOOKUP(F2,Reference!$F$20:$H$22,3,0),0)

I agree, this is what is causing the error and I agree with this fix. However, taking into account the whole context I am still not sure the reference to column I is correct to start with. Week 1, row 6, is the only place where that reference is I. Every other row in every other week it's G.