for your 1st problem you could do this:
=SUM(D4:F8)/ROWS(D4:F8)
simply sums the area then divides by the number of rows of data.
I'm not sure how to help you on the 2nd problem, not with just a formula anyway.
in cell A5 would you like the data to show up as 167, or 16/7?
Bookmarks