[Solved] Average every n-th column based on condition

[Andyfc]

In the attached example-table I have person's names and then a set of data that takes on 4 columns and repeats. The only thing that changes in the data is the first field "Type" and the numbers. As suggested in the example itself, I would like to put in column "Average ALs" the average of all the fields "Points" where "Type"="AL". Accordingly for the other types "M" and "T". The table will expand with time, so that the averages will not stay in columns T, U and V as they are now.

What is the formula to calculate the averages based on the content of field "Type" and looking every 4 columns?

[FJCC]

Your data layout makes calculations difficult. I cannot think of a way to calculate averages without manually designating the cells, which will make adding data tedious and prone to error. I suggest you rotate the data as I show in Sheet2 of the attached file. You can then use either AVERAGEIFS() or a Pivot Table (menu Data -> Pivot Table) to easily do the calculations. Right click on the pivot table and select Edit Layout to see how I set it up.

[Lupp]

From München. A German teacher.

[Andyfc]

From München. A German teacher.

Gruß Gott. I see that a colleague figured out what I needed this for! Plus, your solution seems to really work, which impresses me.

I will play with it more as soon as the Winterferien are over and report back, but it looks very promising indeed.

[Lupp]

An additional suggestion: Place the evaluation next to the participants' names.

Also: Most recent data you are working on in sight: Left hand again.
Prepare for the insertion of additional couples of data.
Don't merge cells.
Check for the column names ("Type", "Points") ...