SUM in column with #N/A showing

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Hi

I have Excel 2003, I have a spreadsheet where the intent is to load various
formulae
and have them costed, there are 30 rows but not all are used each time.
I have a VLOOKUP reporting the cost to a column where I need to total the
cost
but the SUM reports #N/A unless I have each row filled and a cost showing in
each cell.

How can I overcome this?

thanks

Daniel
 
Maybe you could use a formula like:

=SUMIF(a1:a30,"<>#n/a")

or change the =vlookup() to hide those errors:

=if(isna(vlookup(...)),"",vlookup(...))
 
Back
Top