software

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: www.excelforum.com/member.php...oamp;userid=33055
View this thread: www.excelforum.com/showthread...hreadid=533818this is an ARRAY formula so must be entered with ctrl shift enter
=AVERAGE(IF((A2:A22gt;0)*(A2:A22lt;100),A2:A22))

--
Don Guillett
SalesAid Software

quot;inoexcelquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; If I have a list of random numbers down columnA, how would I write up a
gt; formula in another cell that calculates an average of the figures
gt; greater than a certain figure (say, 0) but less than another figure
gt; (500000).
gt;
gt; Thanks
gt;
gt;
gt; --
gt; inoexcel
gt; ------------------------------------------------------------------------
gt; inoexcel's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33055
gt; View this thread: www.excelforum.com/showthread...hreadid=533818
gt;

Great, thanks!--
inoexcel
------------------------------------------------------------------------
inoexcel's Profile: www.excelforum.com/member.php...oamp;userid=33055
View this thread: www.excelforum.com/showthread...hreadid=533818glad it helped

--
Don Guillett
SalesAid Software

quot;inoexcelquot; gt; wrote in
message ...
gt;
gt; Great, thanks!
gt;
gt;
gt; --
gt; inoexcel
gt; ------------------------------------------------------------------------
gt; inoexcel's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33055
gt; View this thread: www.excelforum.com/showthread...hreadid=533818
gt;
You can use the DAVERAGE function.

The function is =DAVERAGE(database,field,criteria)For example:

A B
1 RandomRandom
2 gt;0 lt;500000
3 Random
4 54
5 454540654
6 45345
7 11864
8 154
9 0
10 -154
11 15053=DAVERAGE(A3:A11, quot;Randomquot;, A1:B2)

Hope it works for you.quot;inoexcelquot; wrote:

gt;
gt; Hi,
gt;
gt; If I have a list of random numbers down columnA, how would I write up a
gt; formula in another cell that calculates an average of the figures
gt; greater than a certain figure (say, 0) but less than another figure
gt; (500000).
gt;
gt; Thanks
gt;
gt;
gt; --
gt; inoexcel
gt; ------------------------------------------------------------------------
gt; inoexcel's Profile: www.excelforum.com/member.php...oamp;userid=33055
gt; View this thread: www.excelforum.com/showthread...hreadid=533818
gt;
gt;