=sumif(a:a,"<1e37")

1E37 is just a giant number (1 followed by 37 0's)

Jase wrote:

I have a range of cells that I am summing but that range sometimes change to
either "#value" which throws off my summation or i dont want to summ
duplicates. Basically I want to be able to control my range source as i could
with a graph range. Any ideas?

thanks,

Jase

--

Dave Peterson