[SOLVED] Only average if cells contain a certain word


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.