Use
=MAX(IF(ISNA(A1:A300)=FALSE,A1:A300))
and array enter it (use ctrl+shift+enter)
Same for Min and average
"P Beardshall" <P wrote in message
...
I have lots of tables of data e.g. A1:A12 that is linked to line graphs
and
max/min/average calculations.

The graphs need to plot a zero value when zero is entered but plot nothing
when no data is entered.

I am entering #N/A into the table, this solves the graph problem but
interfears with the max/min/average calculations, they now desplay #N/A.

Is there a way to exclude #N/A from the calculations