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. |
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. |
All times are GMT +1. The time now is 06:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com