excel - Calculate AVERAGE if condition is met in other column -


i know quickest way sum values in column o if have same label in column d, , take average of these values.

my worksheet enormous , number of same label each class different.

how can faster doing manually each label in column d?

please try pivottable columnd rows , average of o values:

so30560025 example


Comments