Average If statement

[Ann]

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.

[Bob Phillips]

=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" <[email protected]> wrote in message
news:[email protected]...
> 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.