I have 3 formulas that are attempting to calculate Innings Pitched across multiple sheets but am returning REF errors for all three. Can someone please make just one of these formulas work!? The formulas originally were written to add just a column but I tried changing them and cant get them to do what I need them too.

So quickly, Innings Pitched is a baseball term for pitchers, 0.3 (3 outs recorded) = 1 inning pitched. ie 0.2 + 0.1 = 1.0.

So my 3 formulas are as follows:

=DOLLARFR(SUMPRODUCT(INT('Game 1:Game 7'!C3)+DOLLARDE(MOD('Game 1:Game 7'!C3,1),3)),3)

=SUMPRODUCT(INT('Game 1:Game 7'!C3))+INT(SUMPRODUCT(ROUND(MOD('Game 1:Game 7'!C3,1),1))/0.3)+MOD(SUMPRODUCT(ROUND(MOD('Game 1:Game 7'!C3,1),1)),0.3)

=SUM(INT('Game 1:Game 7'!C3))+INT(SUM(MOD('Game 1:Game 7'!C3,1))*10/3)+MOD(SUM(MOD('Game 1:Game 7'!C3,1))*10,3)/10

Its almost baseball season, please help!