Thank you. I performed the function, and a 0 appeared. But even then I'm
getting the #VALUE! result.
--
karen


"Niek Otten" wrote:

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