=AVERAGE(IF(A1:A200,A1:A20))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"dbsavoy" wrote in message
...
I'm trying to calculate an average of data, but need to ignore negative
numbers in the range from which I'm taking the average. I'd like to
either
format cells to calculate based on displayed values rather than actual
values
OR use something like an IF function to change negative values into zeros
or
NA.

I would much appreciate any help on this.
Thx!