SOLVED

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

Copper Contributor

# 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 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 Replies
best response confirmed by GNSC4 (Copper Contributor)
Solution

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

"\$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

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

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

Accepted Solutions
best response confirmed by GNSC4 (Copper Contributor)
Solution

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

"\$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