| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I sum a range which includes the "#N/A" VLOOKUP return valu
Excell 2002
I am using numerous VLOOKUP functions (including the "FALSE" option) accross a row to extract exact values from the same range, which may or may not contain the look-up value. I then want to sum accross the row to give me a running total. The problem is that VLOOKUP returns "#N/A" when an exact match is not found; which then returns a "#N/A" error in the sum function. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
| can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
| Dynamic Print Range Help | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
Threaded Mode
