| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Function question | New Users to Excel | |||
| Function question | Excel Worksheet Functions | |||
| Using Average function when number is zero | Excel Worksheet Functions | |||
Linear Mode
