Hi,

If I have a list of random numbers down columnA, how would I write up a formula in another cell that calculates an average of the figures greater than a certain figure (say, 0) but less than another figure (500000).

Thanks