Sum a column that contains #N/A
 

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

Sum a column that contains #N/A
 

Try, eg in F1: =SUMIF(E:E,"<#N/A")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DTTODGG" wrote:
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