How can I replace a range of blank cells with a 0
My formula is not adding due to blank cells on some rows. The formula only
works if I type a 0 on each blank cell. Can someone kindly advice how to fix
this problem? Is there a way of replacing blank ceels with a ? I Tried the
replace function, but that did not work.
Many Thanks
|