Script to create averages of subgroups of rows, depending on content of rows

Hello,

I have a dataset which requires averages to be taken of values in one column, for subsets of rows which share the same values in the other rows. E.g. for all cases where columns A, B, and C match on values, take the average of values in column D.

I would like advice on how to approach this. Would using a script be better? Or trying something using a pivot table perhaps?

In the example attached, I have simply used =AVERAGE() to calculate the average of specified sets of cells in column D. However, in my real dataset (the attached is a simplified example aimed to show what I need to learn to do) there are many thousands of rows, so this would be far from an efficient approach.

I am not sure what approach to take with this problem so would appreciate suggestions for methods to use.

Previously (long time ago!) with a somewhat different dataset, I had a script which generated a new sheet which gave one row for each possible combination of the first columns, and then an average for the final column (averaging all cases where the rows in the original sheet matched) but I cannot remember how / what exactly I did to do that.

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.