Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sum a column with errors
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 |