Shaun,

One way would be to change your formulas so that you don't
het the #N/A (it looks ugly on the worksheet anyway).

Basic format is:

=IF(ISNA(yourformula),"",yourformula)

John

"Shaun" wrote in message
...
how do i hide the #N/A function, as it is affecting my SUM