Formulae to sum up values including special symbol?
 

Hello all, I was trying to figure out if there is a way to write
formulae to sum up the values in the whole column. In this column
there are plenty of cells which has variable like #N/A. Appreciate i
you guys can help me with this problem. Thanks

--
Message posted from http://www.ExcelForum.com

Formulae to sum up values including special symbol?
 

Hi
better would be to change the formulas and avoid #N/A
errors. But try
=SUMIF(A:A,"<#N/A")


-----Original Message-----
Hello all, I was trying to figure out if there is a way
to write a
formulae to sum up the values in the whole column. In
this column,
there are plenty of cells which has variable like #N/A.
Appreciate if
you guys can help me with this problem. Thanks.


---
Message posted from http://www.ExcelForum.com/

.

Formulae to sum up values including special symbol?
 

=sum(if(iserror(A1:A100),"",A1:A100))
Entered with Ctrl+Shift+Enter rather than just Enter since it is an array
formula.

--
Regards,
Tom Ogilvy

"tanks1308 " wrote in message
...
Hello all, I was trying to figure out if there is a way to write a
formulae to sum up the values in the whole column. In this column,
there are plenty of cells which has variable like #N/A. Appreciate if
you guys can help me with this problem. Thanks.


---
Message posted from http://www.ExcelForum.com/