Thread: Trying to find additional ranges outside of min, max, and average
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Trying to find additional ranges outside of min, max, and average
Hi Susan,

Am Sat, 17 Aug 2013 14:36:00 -0700 (PDT) schrieb Susan:

How do I get the value of the range between the maximum and the average?

try:
=SUMIF(E16:BB16,"="&AVERAGE(E16:BB16))/COUNTIF(E16:BB16,"="&AVERAGE(E16:BB16))
And the value between the average and the minimum?

=SUMIF(E16:BB16,"<="&AVERAGE(E16:BB16))/COUNTIF(E16:BB16,"<="&AVERAGE(E16:BB16))


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote