Hello!
In this example I’d like F7 to calculate the average time of the range D5:D29 only if the cell left to it contains the word “Monday” i. e. C7 shall average all times on mondays.
How do I go about solving this?
I think a Pivot Table with a grouping by Weekday might give you the result you need.
Also see AVERAGEIF (like =AVERAGEIF(C5:C29;"Monday";D5:D29)) - but that would only work if your column C actually contains texts, not dates formatted using NNN.
Generally, what @robleyd recommends is better.