Formula Format - Driving Me Nuts

[andreRM]

I keep getting Value Error. Probably a simple thing for one of you, but it is a monster for me.

=SUM(2524+E5-D5)


Many thanks in advance.

André

 

[barry houdini]

what's in E5 and D5?

 

[poorwallace]

looks like either d5 or e5is not a number (though they may look like one)

 

[barry houdini]

In this formula

=SUM(2524+E5-D5)

the SUM function is redundant

this will give the same value

=2524+E5-D5

If this gives you an error then either E5 or D5 is probably text. If they are supposed to be empty then ensure they are and don't contain any spaces or other characters.

If E5 and/or D5 might contain text or numbers and you want to use the numbers when present but ignore text then try

=SUM(2524,E5)-SUM(D5)

or

=2524+N(E5)-N(D5)

 

[andreRM]

Bingo!

You were both right on. I had dashes in one of the columns to represent a filled cell. I changed those dashes to a zero and the formula liked it just fine.

Huge thanks to Barry and Poorwallace. I will sleep well tonight.

Andre.