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

Hi Manny,
Would strongly suggest that if you want help with a formula or anything
else that you indicate what you have tried (the formula) and what it
did instead of work.

Try using the SUM Worksheet Formula it will ignore any cell that is not numeric

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Replacing blank cells" <Replacing blank wrote in message
...
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