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!