In your formulae, add error checking to remove the #N/As; for example set the
cells to blank if there is an error.

Generically, something like:

=IF(ISNA(Myformula),"",Myformula)

HTH

"Todd" wrote:

I am getting a return of #N/A when I try to sum a column. Its a column of
formulas which sometimes return #N/A also. How do I get around this problem
and sum the values I do have?

Thanks.

Todd