Hi Jason

here's two approaches depending on how the data is entered in column B
if it's entered as text - Mon, Tue, Wed etc
then use
=SUMIF(B2:B366,"Sun",C2:C366)/COUNTIF(B2:B366,"Sun")

if it's entered as a date and formatted to show the day of the week then you
can use
=SUMPRODUCT(--(WEEKDAY(B2:B366)=1)*C2:C366)/SUMPRODUCT(--(WEEKDAY(B2:B366)=1))

Cheers
JulieD

"Jason" wrote in message
...
I have sheet containing 365 days column B contains the day of the week
column
c contains a number. I want to average the numbers for each day of the
week.
i.e. average number for "Sun" This is a sheet modified daily and the cells
for the dates that have not occured yet are blank. Any suggestions. Thank
you