Thread: averaging a range
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default averaging a range
Hi,

Try this

=sumproduct((A2:A105)*(A2:A10<15)*(A2:A10))/sumproduct((A2:A105)*(A2:A10<15))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"suprsonic" wrote in message
...
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.

Reply With QuoteReply With Quote