SUM Statements are not including IF

[Gian S]

I'm working on several worksheets and I have an IF statement that brings back
a value onto on of my worksheets and If I do a sum of several Cells which
includes the IF statement value, the SUM value of the cells does not include
the IF statement values.

[daddylonglegs]

Sounds like the IF statement is returning text not a number (although it may look like a number), you may need to add a +0 to your IF formula, this will convert to a value that can be summed.

What's your If formula?