I have pulled down a function for a column.
the problem some of the values that this fn refers to are blank so i
get #value! message.
I want to give all cells with the #value! in them 0 so I can SUM the
column
how do i do that


--
sik_chode
------------------------------------------------------------------------
sik_chode's Profile: http://www.excelforum.com/member.php...o&userid=26007
View this thread: http://www.excelforum.com/showthread...hreadid=393666