CODEWITHSUNDEEP
excelexcel-formulaaveragepivot-table
micos
micos

Reputation: 19

Calculate AVERAGE if condition is met in other column

I would like to know the quickest way to sum all the values in column O if they have the same label in column D, and take the average of these values.

My worksheet is enormous and the number of the same label for each class is also different.

How can I do this faster than doing this manually for each label in column D?

Upvotes: 1

Views: 918

Answers (1)

pnuts
pnuts

Reputation: 59460

Please try a PivotTable with ColumnD for ROWS and Average of O for VALUES:

SO30560025 example

Upvotes: 2

Related Questions