Table with row values based on multiple date ranges

I have attached a sample file.

In column A, I have a list of dates.

In column B, I have a list of numbers.

I would like to create a table in which the first row shows the average count of the numbers in rows 2-11, and the second row shows the average count of the numbers in rows 12-21.

Ideally, I'd like the bottom row (grand total) to be average, not sum.

What do you mean by "average count" ? Do you mean you want the average of the numbers from rows 2 to 11, and then 12 to 21, and so on ?

Pete

You can use this formula, say in D2:

=AVERAGE(INDEX(B:B,(ROWS($1:1)-1)*10+2):INDEX(B:B,ROWS($1:1)*10+1))

and then copy it into D3 for the next block of numbers.

I'm not sure what your final sentence means.

Hope this helps.

Pete