Hey :-)

This is Sadra. I'm working on my master thesis on Remote Sensing and urban Heat Islands. I need a help with calculating average values in excel, and I appreciate any help of you.
So I have two columns of data, named "Grid" and "Temperature" (snapshot included below):

Capture.JPG

I would like to calculate the average of column B (Temperature), BUT based on the length of the values in Column A (Grid). In other words, I want the average of B2:B9, B10:B12, B13:B15 and so on.


Many thanks in advance for your help,
Best Regards,
SAdra