MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT.

[Guest]

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

 

[Ben McBen]

Well if there all positive:

=SUMIF(F7:F10,">0")

should work

 

[Guest]

Hi
change your formula to
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))