Hi,

Encountered another problem! I need to find out the average for a large dataset for a group of values that include dates from Monday - Sunday but I am only interested in averaging Monday-Friday.

I have the date in a row above the dataset that clearly shows the day (Monday/Tuesday/Wednesday etc derived from a "#####"/"41457" format (which happens to be a Tuesday or a number 2, the next Tuesday in the dataset is number 9 etc).

Something like this is needed I guess?

=SUMIFS(D6:GI6, D5:CE5, Monday OR Tuesday OR Wednesday OR Thursday OR Friday)/COUNTIF(D6:GI6, D5:CE5....

Any help would be awesome.

Cheers,

HC