| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sum a column with errors
It's better to fix the #N/A errors but sometimes you may want to know if
there is an error. This will sum a range and ignore any #N/A errors: =SUMIF(A1:A10,"<#N/A") Biff "blkane" wrote in message ... I have a column where the cells contain a vlookup formula for an exact match only. If there is no match, the value N/A# is returned. However, I would like to be able to sum the values that the vlookup does find. How do you write the formula so that instead of returning N/A# it returns zero or blank if the vlookup can't find a match? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum some cells in column but not #n/a errors | Excel Discussion (Misc queries) | |||
| Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
| MAX value of a column that has #div/0 errors in it | Excel Discussion (Misc queries) | |||
| SUM a column with errors | Excel Worksheet Functions | |||
| Summing a Column wit errors? | Excel Worksheet Functions | |||
Threaded Mode
