=AVERAGE(IF((A1:A30=J1)*(A1:A30<=K1),B1:B30))

entered with ctrl + shift & enter where K1 is the first date of the week and
K1 the last

--
Regards,

Peo Sjoblom

(No private emails please)


"BarrySandell" wrote in message
...
I have an Excel spreadsheet of daily totals where some days have no values
and some days have several values. I want to consolidate this into weekly
totals. Any ideas?