=AVERAGE(IF((A1:A20>0)*(A1:A20<=10),B1:B20))

as an array formula, so commit with Ctrl-Shift-Enter.

Just change the 0 and the 10 for other ranges.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sterling" <[email protected]> wrote in
message news:[email protected]...
>
> I know just enough in Excel that I know I can get the info I want but
> not enough to know how to do it. Any help would be much appreciated. I
> am working with 2 columns of data, for example:
>
> Days in Stock____________Cost
>
> 2_____________________$300
> 21____________________$400
> 117___________________$600
> 8_____________________$400
> 37____________________$500
> 78____________________$500
>
> What I want to calculate is the average cost for 0-10 days in stock
> (($300 + $400)/2= $350), the average cost for 11-60 days in stock, and
> the average cost for 60+ days in stock.
>
> What sort of formula would best calculate this? TIA.
>
>
> --
> Sterling
> ------------------------------------------------------------------------
> Sterling's Profile:
http://www.excelforum.com/member.php...o&userid=29554
> View this thread: http://www.excelforum.com/showthread...hreadid=492585
>