ExcelBanter - #N/A in a column I want to add

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - #N/A in a column I want to add (https://www.excelbanter.com/excel-worksheet-functions/120922-n-column-i-want-add.html)

CINDY

#N/A in a column I want to add

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?

All times are GMT +1. The time now is 05:41 AM.