Trouble summing column with errors in cells

  • Thread starter Thread starter DOOGIE
  • Start date Start date
D

DOOGIE

I am using Excel 2003. I have a spreadsheet set up to calculate values
recorded from another application on a daily basis for the entire year. For
the present day and previous days, there are numerical values in the cells.
For future days the error statement "#VALUE" is in the cells. When I try to
sum a column that has #VALUE in some cells and numerical values in the rest
of the cells, I get the same error statement #VALUE for my sum. Is there a
way that I can sum a column with #VALUE listed in some cells and numerical
values in the other cells and get a numerical value for the sum of the cells
that have a numerical value stored in them? I am trying to keep the
spreadsheet as automatic as possible.
 
Hi there DOOGIE,

You can use this formula to ignore all text and errors in your formula and
just calculate the actual amounts.
Hope this helps you
=SUM(IF(ISERROR(A1:A10),"",A1:A10))


Regards
Garreth
 
Back
Top