invisigirl
Board Regular
- Joined
- Mar 18, 2002
- Messages
- 130
Okay. I've heard people say that you should not get a #VALUE! error simply because of blank cells - that a blank cell is interpreted as zero. Well, that does not seem to be the case for me. I have a spreadsheet that is summing data in column W for all the previous cells (Ex: A3:V3) in that row. Row 1 will be fine, row 2 will be fine, but row 3 doesn't have any data, so cell W3 displays the error message "#VALUE!"
Now, in cell W26, I'm summing W1:W25. I have 3 instances in column W where the formula result displays as #VALUE!. Therefore, W26 is also displaying as #VALUE!.
So, in very literal terms (because I'm much more of an English person than a computer guru), could someone explain to me how to fix this?
Thanks in advance to all the smarties!
Now, in cell W26, I'm summing W1:W25. I have 3 instances in column W where the formula result displays as #VALUE!. Therefore, W26 is also displaying as #VALUE!.
So, in very literal terms (because I'm much more of an English person than a computer guru), could someone explain to me how to fix this?
Thanks in advance to all the smarties!