Nick,

For the weekend average,

=SUMPRODUCT((WEEKDAY(A1:A365,2)5)*B1:B365)/SUMPRODUCT((WEEKDAY(A1:A365,2)5)*1)

For the weekday average
=SUMPRODUCT((WEEKDAY(A1:A365,2)<6)*B1:B365)/SUMPRODUCT((WEEKDAY(A1:A365,2)<6)*1)

HTH,
Bernie
MS Excel MVP


"Nick" wrote in message
...
I'm trying to average a column of numbers based on the day of the week.
Col A has the sequential days of the month, Col B has a number for each day.
I want to average all the numbers in Col B that are based on a weekday or
weekend.
--
Thanks,
Nick