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


--
inoexcel
------------------------------------------------------------------------
inoexcel's Profile: http://www.excelforum.com/member.php...o&userid=33055
View this thread: http://www.excelforum.com/showthread...hreadid=533818