Weekends: =SUMPRODUCT(--(WEEKDAY(A2:A10,2)5),B2:B10)
Weekdays: =SUMPRODUCT(--(WEEKDAY(A2:A10,2)<=5),B2:B10)
--
HTH
Bob Phillips
"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
|