=sum(if(isnumber(a1:b4000),a1:b4000))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.

cs_vision wrote:

I have a range of 8000 cells that contain #VALUE!, I need to find the sum
for the cells contained in the range with numbers.

--

Dave Peterson