Very New Need Help With Average

[meetbalips]

How do I find the average time of each letter?

Time in Seconds	Label 1	Label 2	Label 3
56	A	B	P
98	R	E	G
77	R	T	O
41	R	Q	G

 

[Saurabhj]

Hi, use averageif formula.

=AVERAGEIF($B$2:$B$5,B8,$A$2:$A$5)

As the labels are in different column, is it possible to change the data set?

fso.xlsm
	A	B
1	Time in Seconds	Label 1
2	56	A
3	98	R
4	77	R
5	41	R
6	56	B
7	98	E
8	77	T
9	41	Q
10	56	P
11	98	G
12	77	O
13	41	G
Sheet3

 

[meetbalips]

No, I can't or don't know how. The real file has over 20k rows and columns over to GG.