How to use =Sum on a column that has an IF statement for Currency

[GNSC4]

so I'm attempting to sum the value of Column F in Column G at the top and bottom of the document but Column F uses the formula =IF(A#>0,"$6.000","") and so when I used Sum on G it gives me an error saying Inconsistent Calculated Column Formula. Does anyone know how to resolve this error? I have tried using =SUM(F2:F225) and =SUM([Fee]) both return the same error and can be seen in the document attached.

[#2 · Accepted solution]

@GNSC4 

"$6.00" is a text value, not a number or currency value. SUM ignores all text values.

Change the formula to

=IF(A2>0,6,"")

or to

=IF([@[Game '#]]>0,6,"")

and it will work as intended

[#3]

Thank you so much been stuck on this for 2 hours and it was that simple XD