Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last Number to Average
Is it possible to average up to certain row indicated in "Last number to average" or C8 A B C 1 5 2 7 3 8 4 10 5 6 6 10 7 8 Last number (NO.) to average: 4 (i would like to average from A1 to A4) REsult = 7.5 or (5+7+8+10)/4 Thanks much -- yirawan ------------------------------------------------------------------------ yirawan's Profile: http://www.excelforum.com/member.php...o&userid=29036 View this thread: http://www.excelforum.com/showthread...hreadid=487681 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last Number to Average
=AVERAGE(OFFSET($A$1,0,0,A8,1)). This will start in A1 and average the
number of rows indicated in A8. "yirawan" wrote: Is it possible to average up to certain row indicated in "Last number to average" or C8 A B C 1 5 2 7 3 8 4 10 5 6 6 10 7 8 Last number (NO.) to average: 4 (i would like to average from A1 to A4) REsult = 7.5 or (5+7+8+10)/4 Thanks much -- yirawan ------------------------------------------------------------------------ yirawan's Profile: http://www.excelforum.com/member.php...o&userid=29036 View this thread: http://www.excelforum.com/showthread...hreadid=487681 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last Number to Average
bpeltzer wrote...
=AVERAGE(OFFSET($A$1,0,0,A8,1)). This will start in A1 and average the number of rows indicated in A8. .... Variation on this using nonvolatile functions. =AVERAGE($A$1:INDEX($A:$A,A8)) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Last Number to Average
thanks much -- yirawan ------------------------------------------------------------------------ yirawan's Profile: http://www.excelforum.com/member.php...o&userid=29036 View this thread: http://www.excelforum.com/showthread...hreadid=487681 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - Average of counts | Excel Worksheet Functions | |||
Average of count in pivot tables | Excel Worksheet Functions | |||
Count number of runs above or below average | Excel Worksheet Functions | |||
average function in Excel 2002 | New Users to Excel | |||
Random Number Questions | Excel Worksheet Functions |