Trouble summing column with errors in cells

[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.

 

[Garreth Lombard]

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