Average If statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofilter on Day 8
need help writing function 9
Average Time 6
average if question 2
Yet another Average Function with mutl. Columns 3
WEEKDAY 7
Average last seven if not zero 5
How to format cell to get first capital letter? 5

Back
Top