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


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


Use AVERAGEIF() or a pivot table.