| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT.
Hello, my vlookup is returning n/a values which is ok. I still want the
column to add the totals of the vlookups but at the moment the total cell is showing n/a because some of the vlookups are returning n/a values. Can I still get a total sum of the column even though some of the vlookups are showing n/a |
|
#2
|
|||
|
|||
|
Well if there all positive:
=SUMIF(F7:F10,"0") should work |
|
#3
|
|||
|
|||
|
Hi
change your formula to =IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...)) "Martin" wrote: Hello, my vlookup is returning n/a values which is ok. I still want the column to add the totals of the vlookups but at the moment the total cell is showing n/a because some of the vlookups are returning n/a values. Can I still get a total sum of the column even though some of the vlookups are showing n/a |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
