Finding an average of cells with an Id

Copper Contributor

Hi All

Could anyone give advice on finding the average of a set of numbers linked to a cell ID

Average.png

I would like it displayed as below 

Av Scree.png

I have calculated this manually but I have a ton of data to average

 

Many Thanks

1 Reply

@Tosti170 

Use AVERAGEIF() or a pivot table.