Hello,

I have a worksheet that I am using a VLOOKUP to get amounts for a
calculation. This is partial data, so, I have many #N/A in the column along
with other cells that contain real numbers.

How can I "SUM" this column (basically ignoring the "N/A" until they are
updated. with real numbers). I'd like this running total, because a few of
the rows may never update.

Thank you