Average function question
 

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?


--
chapm4
------------------------------------------------------------------------
chapm4's Profile: http://www.excelforum.com/member.php...o&userid=16259
View this thread: http://www.excelforum.com/showthread...hreadid=500353

Average function question
 

DataSubtotals, choose Use function Average

--
Kind regards,

Niek Otten

"chapm4" wrote in
message ...

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?


--
chapm4
------------------------------------------------------------------------
chapm4's Profile:
http://www.excelforum.com/member.php...o&userid=16259
View this thread: http://www.excelforum.com/showthread...hreadid=500353

Average function question
 

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!


--
chapm4
------------------------------------------------------------------------
chapm4's Profile: http://www.excelforum.com/member.php...o&userid=16259
View this thread: http://www.excelforum.com/showthread...hreadid=500353

Average function question
 

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

Is that correct?

--
Kind regards,

Niek Otten

"chapm4" wrote in
message ...

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!


--
chapm4
------------------------------------------------------------------------
chapm4's Profile:
http://www.excelforum.com/member.php...o&userid=16259
View this thread: http://www.excelforum.com/showthread...hreadid=500353

Average function question
 

That Works perfect Thanks


--
chapm4
------------------------------------------------------------------------
chapm4's Profile: http://www.excelforum.com/member.php...o&userid=16259
View this thread: http://www.excelforum.com/showthread...hreadid=500353