Dear All,

I am trying to calculate a column in Excel but some of the cells within the
column have #Value in them because of other calculations within the
worksheet. Is there anyway to calculate the numbers in a column (in this case
the number are set as a currency) and ignore the #Value that is in some of
the cells.

Thanks