Hi,

You can also try

=sumif(range,"<0")+sumif(range,"0")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Riley" wrote in message
...
I want to sum a range of 10 cells that already have formulas in them to
auto
populate as I enter data elsewhere......If I want to sum these cells
before
they have all been populated, I get a "N/A" return. Can someone tell me
how
to sum these cells and ignore the cells that don't have data yet?