View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SCC SCC is offline
external usenet poster
 
Posts: 11
Default Need MAX value if condition is met

I have a spreadsheet that lists usage in our computer lab. From the data I
am able to get the average usage for each day using the averageif function
=AVERAGEIF(Adjusted!$B$3:$B$25,"Thu",Adjusted!$I$3 :$I$25). How can I get the
max value for each day. There is no maxif or 'if.. then' functions.