View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deb Pingel
 
Posts: n/a
Default Average of a , < range


Does anyone know how to average a range of numbers based on a criteria,
where the numbers have to fall within a range of data? I have tried
combining a number of statements and nothing is working. I want to
average a column of numbers that will have data added to it every day,
but throw out anything over 4 and under 14.


--
Deb Pingel
------------------------------------------------------------------------
Deb Pingel's Profile: http://www.excelforum.com/member.php...o&userid=20119
View this thread: http://www.excelforum.com/showthread...hreadid=495354