SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2750797%22%20slang%3D%22en-US%22%3EHow%20to%20use%20%3DSum%20on%20a%20column%20that%20has%20an%20IF%20statement%20for%20Currency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2750797%22%20slang%3D%22en-US%22%3E%3CP%3Eso%20I'm%20attempting%20to%20sum%20the%20value%20of%20Column%20F%20in%20Column%20G%20at%20the%20top%20and%20bottom%20of%20the%20document%20but%20Column%20F%20uses%20the%20formula%20%3DIF(A%23%26gt%3B0%2C%22%246.000%22%2C%22%22)%20and%20so%20when%20I%20used%20Sum%20on%20G%20it%20gives%20me%20an%20error%20saying%20Inconsistent%20Calculated%20Column%20Formula.%20Does%20anyone%20know%20how%20to%20resolve%20this%20error%3F%20I%20have%20tried%20using%20%3DSUM(F2%3AF225)%20and%20%3DSUM(%5BFee%5D)%20both%20return%20the%20same%20error%20and%20can%20be%20seen%20in%20the%20document%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2750797%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2750871%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20use%20%3DSum%20on%20a%20column%20that%20has%20an%20IF%20statement%20for%20Currency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2750871%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1074329%22%20target%3D%22_blank%22%3E%40GNSC4%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%22%246.00%22%20is%20a%20text%20value%2C%20not%20a%20number%20or%20currency%20value.%20SUM%20ignores%20all%20text%20values.%3C%2FP%3E%0A%3CP%3EChange%20the%20formula%20to%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(A2%26gt%3B0%2C6%2C%22%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eor%20to%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(%5B%40%5BGame%20'%23%5D%5D%26gt%3B0%2C6%2C%22%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eand%20it%20will%20work%20as%20intended%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 (New Contributor)
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

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