SUM problem

[mmode66]

I have a simple =SUM(A1:G1) formula here but it's not working.
It's like it's missing column data and giving incorrect totals.

Each result (A:G) is populated by an IF formula.

Any thoughts why Sum would not be working properly?
Auto Calculation is on, which is the only thing i can think of to check.

[TABLE="width: 512"]
<colgroup><col style="width:48pt" span="8" width="64"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]PROD[/TD]
[TD="class: xl64, width: 64"]SRPHR[/TD]
[TD="class: xl64, width: 64"]XSPHR[/TD]
[TD="class: xl64, width: 64"]IBPHR[/TD]
[TD="class: xl64, width: 64"]Rev Kck[/TD]
[TD="class: xl64, width: 64"]XS Rev[/TD]
[TD="class: xl64, width: 64"]Rev/Dispo[/TD]
[TD="class: xl64, width: 64"]Totals[/TD]
[/TR]
[TR]
[TD="class: xl65"][/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl67"]1[/TD]
[TD="class: xl66, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl67"]4[/TD]
[TD="class: xl66, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl67"]6[/TD]
[TD="class: xl66, align: right"]12[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Can you post what your IF formulas look like?
I suspect that they are returning text and not numbers.
The values you want to return should NOT have double-quotes around them in your IF formulas.
If they do, they will return text and not numbers, and your SUM formula will not work properly.

 

[mmode66]

No need to post it. You nailed it in your answer. Took out the "" and it's working perfectly. Didn't know that effected the formula like that. Thank you very much for the help

 

[Joe4]

You are welcome.
Yes, anything between double-quotes is treated as literal text.