#N/A in a column I want to add
 

Assuming your header in A1 and your data start from A2:A1000
Go to Data Filter Auto Filter Select #NA enter 0 then copy all the
way down. It will replace all the #N/A to 0 . Remove the filter


"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?