JoeK210185
New Member
- Joined
- Apr 1, 2009
- Messages
- 36
Hello
I've got a formula =SUM(C3+H3+M3+R3+W3+AB3+AG3+AL3+AQ3+AV3)
Pretty simple, but if say, H3, was a blank cell, it is returning a #VALUE!
Now i know it has to be a true blank cell, which it is, but if i put in a random figure, lets jsut say 1, then the formula works out, if i then delete the 1, the formula still says working, even though it is exactly the same as it was before, with the same figures in each cell an the same cells being true blanks?
I'm just looking for anyone who may be able to help me!
Oh, and on my options, calculation is on automatic
I've got a formula =SUM(C3+H3+M3+R3+W3+AB3+AG3+AL3+AQ3+AV3)
Pretty simple, but if say, H3, was a blank cell, it is returning a #VALUE!
Now i know it has to be a true blank cell, which it is, but if i put in a random figure, lets jsut say 1, then the formula works out, if i then delete the 1, the formula still says working, even though it is exactly the same as it was before, with the same figures in each cell an the same cells being true blanks?
I'm just looking for anyone who may be able to help me!
Oh, and on my options, calculation is on automatic