View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ann ann is offline
external usenet poster
 
Posts: 210
Default 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.