<Blank cells don't give #VALUE when summed, cells with spaces do.

Not entirely true; the SUM() functions ignores spaces, individual additions don't.
So don't rely on that, always make sure values to be added are numeric

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message ...
| Hi Karen,
|
| Blank cells don't give #VALUE when summed, cells with spaces do.
| You can check with the LEN() function; if the result is not zero, there's something in the cell.
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "karen" wrote in message ...
|| I'm downloading data from a database into Excel; some of the cells have $0
|| values, but some are just blank. If I sum a row or a column which includes a
|| blank cell, I get an error message: #VALUE! How can I convert the blank
|| cells to zeros?
|| --
|| karen
|
|