Greetings,

I have a VLOOKUP and some of the results are #N/A as there is no data for
that cell. I need to sum the rows of cells, including those with #N/A (those
values would then be 0).When I try to add the results those error cells do
not let me add up the other cells with real values.


What is the best way to do this? I am okay with adding another column if
needed

Thank you in advance for your advice!