Column G will not SUM up using formula =SUM(G:G542)

I am trying to sum column G in cell G2 with the formula

=SUM(G4:G542)

Each of the referenced cells has this formula in it

=IF(F4=1,"600.00","")

I believe It is because of this formula in the referenced cells that the formula in G2 will not calculate.

Is there a way to sum up this column?

"600.00" is a text string, and Excel's SUM() function is programmed to ignore text strings. Return a real number -- 600 (without the quotation marks). =IF(F4=1,600,"")