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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Average If statement
=AVERAGE(IF(P19:P1000="Sunday",L19:L1000))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ann" wrote in message ... 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. |
Reply |
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 |