To sum a range that contains errors:

=SUMIF(A1:A10,"<1E100")

To average a range that contains errors:

Array entered**

=AVERAGE(IF(ISNUMBER(A1:A10),A1:A10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

To not print errors:

In Excel 2002:

FilePage SetupSheet tab
Under Print...Cell errors asselect blank
OK

--
Biff
Microsoft Excel MVP


"PaulinaDi" wrote in message
...
I'm using a formula to bring results from another worksheet but in some
cases
I get the #N/A result as I don´t have data on the original worksheet. To
get
the graphics on the final worksheet I use the formula with NA() not to
give
me 0 values on the chart and I also use the conditional formula to get the
#N/A results just like the cells were empty (the same color I use for that
cell) but when I print my page, I get the #N/A in black (so I can see
them)
and additional I'm not able to get a SUM or AVERAGE on each column as I
get
the #N/A for those cells with that mark.

Two examples of the formula I'm using a

=IF(SUMPRODUCT(--('2009'!$B$8:$B$256=$O14),--('2009'!$B$8:$B$256<$O15))=0,NA(),SUMPRODUCT(--('2009'!$B$8:$B$256=$O14),--('2009'!$B$8:$B$256<$O15),('2009'!E$8:E$256))/SUMPRODUCT(--('2009'!$B$8:$B$256=$O14),--('2009'!$B$8:$B$256<$O15)))

=IF(L9/L8-1=0,NA(),L9/L8-1)

How may I get the SUM or the AVERAGE for that column and how may I print
my
file without seeing the #N/A's in black?