SUM ignores blanks and text so you have something else happening.

Post the actual formula you are using and a small sample of data.


Gord Dibben MS Excel MVP

On Fri, 11 Jan 2008 09:20:01 -0800, karen
wrote:

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?