VLOOKUP #N/A
2 Answer(s)
Bertrand
0") should work">
0") should work">
If they are all positive:
=SUMIF(F7:F10,">0")
should work
Jan 09 2014 12:39 PM
=SUMIF(F7:F10,">0")
should work
Sandhya
To perform mathematical operations on your VLOOKUP results, you need to replace the #N/A error with a 0 value (or something similar). This can be done with a formula that utilizes a combination of the VLOOKUP function, IF function, and ISNA function.
Jan 09 2014 04:00 PM