Hello,

What would be the best approach or what Excel formula would you use to determine averages for the groups of 3-digit values shown in the following screenshot (Fig. 1):

Note that the number of values varies in each group as shown by the horizontal lines included in Fig. 2:

*(Note: the numbering in column C was obtained by entering the formula: =IF(B3<>"",1,C2+1) in cell C3 and pasting down.)*
The goal is find a formula which:

a) can determine how many values are present in each group so it

b) calculates the average based only on each group's values and

c) displays the result (col E) in the same row as its corresponding group title (Fig. 3):

Thanks