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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. (https://www.excelbanter.com/excel-discussion-misc-queries/1766-my-vlookup-returning-n-therefore-my-total-sum-bot.html)

Martin

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

Ben McBen

Well if there all positive:

=SUMIF(F7:F10,"0")

should work

Frank Kabel

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

All times are GMT +1. The time now is 02:20 AM.