Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if condition | Excel Discussion (Misc queries) | |||
if condition | Excel Discussion (Misc queries) | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
Combine an OR condition with an AND condition | Excel Discussion (Misc queries) | |||
Condition 1 overules condition 2? | Excel Worksheet Functions |