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/120902-re-n-column-i-want-add.html)

Max

#N/A in a column I want to add

Try: =SUMIF(A:A,"<#N/A")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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?

All times are GMT +1. The time now is 02:18 AM.