SUM Statements are not including IF
 

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.

SUM Statements are not including IF
 

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?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=513403