SUM Statements are not including IF

G

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.
 
D

daddylonglegs

Sounds like the IF statement is returning text not a number (although i
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
 
Top