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.

Try changing the formula that creates the #value! error so it doesn't.
ie
=if(a1=0,"",a2/a1)

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=562244