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

It seems like you are on the correct path to your answer. The only missing component is the WHERE clause. Essentially, you need to specify to do averages WHERE it = a particular value. So, your groups' numbers can continue to grow and your formula will compute based on the groups' names.

See screenshot:

=AVERAGEIF(B7:B12,"A",D7:D

=AVERAGEIF(B7:B12,"B",D7:D

=AVERAGEIF(B7:B12,"C",D7:D

...etc