Average function question

C

chapm4

sure this is easy for you smart ones.......

Column A has identifiers for locations 1-11
Column B has test scores
I want average test scores for each of the locations


1 6.8
9 12.9
1 12.9
2 11.3
2 12.9
2 7.7
2 7.7
9 12.9
1 10.8
1 12.9
11 12.9

Can anyone help
 
C

chapm4

That sure was quick and easy, thanks for pointing out something I didn't
know was there but, I am getting a divide by zero error when I do this.

Formula is: =SUBTOTAL(1,D2:D36)


1 12.9 12.9
1 9.4 8.7
1 10.3 9.4
1 10.8 5.2
1 12.9 8.9
1 8.6 10.9
1 8.1 8.0
1 10.3 10.1
1 Average #DIV/0!
 
N

Niek Otten

I think you selected one column too many; it should have been Column C, not
D

Is that correct?
 
Top