You have to trap errors in the formulas that produce your columns of numbers.

Post the formula you're using which returns #N/A and someone can show you
how to modify it to trap errors. Once modified, just fill it down the column.

Dave
--
Brevity is the soul of wit.


"Cindy" wrote:

I have a huge column of data that needs to be added. My problem is that I
have quite a few #N/A in the column. Is there any way to get this column to
add without going through and manually making the #N/A zeros?