Forum Discussion
Solved
How to use =Sum on a column that has an IF statement for Currency
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 s...
"$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
"$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
Thank you so much been stuck on this for 2 hours and it was that simple XD