Sum a column that contains #N/A

[DTTODGG]

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

 

[Max]

Try, eg in F1: =SUMIF(E:E,"<>#N/A")