How do I average a range of numbers between two criteria? For instance, I'd
want to average only numbers greater than 5 and less than 15.

=(SUMIF(A1:A5,">5")-SUMIF(A1:A5,">=15"))/(COUNTIF(A1:A5,">5")-COUNTIF(A1:A5,">=15"))

In Excel 2007 and later you can use the AVERAGEIFS function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"suprsonic" <(E-Mail Removed)> wrote in message
news:7D867D7F-1A94-4F26-ADA7-(E-Mail Removed)...
> How do I average a range of numbers between two criteria? For instance,
> I'd
> want to average only numbers greater than 5 and less than 15.

If you have Excel 2007, use the Averageifs function, as in:
=AVERAGEIFS(C7:C11,C7:C11,">5",C7:C11,"<15")

Regards,
Fred

"suprsonic" <(E-Mail Removed)> wrote in message
news:7D867D7F-1A94-4F26-ADA7-(E-Mail Removed)...
> How do I average a range of numbers between two criteria? For instance,
> I'd
> want to average only numbers greater than 5 and less than 15.

Hi,

Try this

=sumproduct((A2:A10>5)*(A2:A10<15)*(A2:A10))/sumproduct((A2:A10>5)*(A2:A10<15))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"suprsonic" <(E-Mail Removed)> wrote in message
news:7D867D7F-1A94-4F26-ADA7-(E-Mail Removed)...
> How do I average a range of numbers between two criteria? For instance,
> I'd
> want to average only numbers greater than 5 and less than 15.