hey Max,

Greeting from Wessex

The best part is that you used the ,2 argument to make the list simpler, but
stopped one step short

=AVERAGE(IF(WEEKDAY(A1:A8,2)={1,2,3,4,5},B1:B8))

which I think is as previous.

Be content in that the concept was the best though <g

Bob

"Max" wrote in message
...
"Bob Phillips" wrote
I like this answer best Max, but haven't we been here before
=AVERAGE(IF(WEEKDAY(A1:A8,2)<=5,B1:B8))
<EVBG

Yes (scratch-scratch) I vaguely recollect .. the conditional formatting
episode ? <bg. Heck, it's now confirmed as one of my several blind
spots:
that 1 week = 7 days only, Bob ! Cheers.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----