Calculating average of triplicates in a single column of data

[nerdyguy29]

Hi,
I need to calculate the averages from a column of triplicate data, and am struggling to find and correctly use a formula to do this.
Here's what the data looks like:
Column A Column B Column C
ID number Trial number Measurement
1 1 100
1 2 50
1 3 50
2 1 200
2 2 150
2 3 148
3 1 125
3 2 99
3 3 110


Any help would be greatly appreciated. Thanks!!

 

[jtakw]

Hi,

Use AVERAGEIF:

Excel 2010
	A	B	C	D	E	F
1	ID Number	Trial Number	Measurement		ID Number	Avg. Measurement
2	1	1	100		1	66.66666667
3	1	2	50		2	166
4	1	3	50		3	111.3333333
5	2	1	200
6	2	2	150
7	2	3	148
8	3	1	125
9	3	2	99
10	3	3	110
Sheet1

Cell Formulas
Range	Formula
F2	=AVERAGEIF(A$2:A$10,E2,C$2:C$10)

F2 formula copied down.

 

[nerdyguy29]

Thank you so much! Worked perfectly!! Keep up the great work!!

Hi,

Use AVERAGEIF:

Excel 2010

	A	B	C	D	E	F
1	ID Number	Trial Number	Measurement		ID Number	Avg. Measurement
2	1	1	100		1	66.66666667
3	1	2	50		2	166
4	1	3	50		3	111.3333333
5	2	1	200
6	2	2	150
7	2	3	148
8	3	1	125
9	3	2	99
10	3	3	110

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula F2 =AVERAGEIF(A$2:A$10,E2,C$2:C$10) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

F2 formula copied down.

 

[jtakw]

You're welcome, welcome to the forum.