View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Divercem Divercem is offline
external usenet poster
 
Posts: 4
Default When Averaging a column, exclude value based on another cell value

Column C contains the day of the Week. Column D contains the clock-in time.
Column E contains the end of the day clock-out time. I am currently using
the formula =Average(D:D).

When averaging a column of clock-in times, can the values for Saturday &
Sunday be excluded? I'm using column notation because the length of the
column is variable.

Thanks,

Charlie