| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| values greater than and including | Excel Worksheet Functions | |||
| Is there a special character for "ALT+ENTER" for text formulae? | Excel Discussion (Misc queries) | |||
| How to detect symbol/special character code | Excel Discussion (Misc queries) | |||
| Excel: 'always choose same cell' symbol for use in formulae | Excel Discussion (Misc queries) | |||
| Calculate averages not including zero values | Excel Discussion (Misc queries) | |||
Linear Mode
