| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove #n/a in vlookup to sum results
You could try something like this:
=SUMIF(C2:D2,"<#N/A") which will ignore the error Any good? Hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "duketter" wrote: Excel 2007 - I have vlookup formulas in cell c2 and d2. In c2 the result of the vlookup is 5 and in d2 the results of the vlookup is #n/a. I then need to sum cell c2 and d2 but I cannot since d2 contains #n/a. How can I remove/change this so I can sum these two cells together? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum the results of a vlookup | Excel Worksheet Functions | |||
| Remove Negative Signs from Formula Results | Excel Worksheet Functions | |||
| Sum results of VLOOKUP | Excel Worksheet Functions | |||
| Vlookup with two results | Excel Discussion (Misc queries) | |||
| to sum up all value results from VLOOKUP | Excel Worksheet Functions | |||
Threaded Mode
