| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Average If statement
I need to average DaysOpen by specific days, but having trouble with the
formula. Any assistance would be appreciated. Date: I19:I1,000 DaysOpen: L19:L1,000 WeekDay: P19:P1,000 ("Monday", Tuesday", etc. - this field equals column I, but with Day format) Result I'm looking for is: Sunday = 2.35 Monday = 5.46 Tuesday = 3.46 etc. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement combining average | Excel Discussion (Misc queries) | |||
| Getting an average using if statement | Excel Discussion (Misc queries) | |||
| If Statement not to include O when doing average | Excel Discussion (Misc queries) | |||
| If statement then Average | Excel Discussion (Misc queries) | |||
| Average with more than one IF statement | Excel Worksheet Functions | |||
Threaded Mode
