Keep returning #VALUE! error when trying to calculate a sum off of two different formula results

[kellywy]

I'm baaaa-aaaack! With yet another (potentially) idiotic question - because it seems SO simple, and I've never run across this before. But I really have spent 97 minutes trying to solve it. So - here I am.

Cell I7 has a formula that works fine in the entire column. =IF(F7=0,"",E7)

Cell M7 has a formula that works fine in the entire column. =IF(H7="","",H7-F7)

I'm trying to put a result of Cell I7-M7 into K7 (and the whole column). =sum(I7-M7)

The results I get in Column K are:
If I7-M7 = 0, I get a 0
If it = more or less than 0, I get #VALUE !

Where am I crazy??? (and thanks for any help!!!)

 

[jtakw]

Hi,

That's probably because one of the cells, either I7 or M7 has "" value in it, in this case, what would you want as a result?

 

[kellywy]

Hmm. That's interesting! I'm looking for a numerical result - which again, I get if the answer is 0 -- but in some cases it would be, for example, 90-45=45. And.........I just fixed those formulas in columns I & M........and problem solved! THANK YOU SO MUCH!!!!!!

 

[jtakw]

You're welcome, Happy you got it fixed.