Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What is the formula to sum the last ten entries in a row in an Ex.
I am trying to calculate a running average of the last 10 items I place in a
row. Is there an easy way to do this? |
#2
|
|||
|
|||
Assumes your list starts in A1 and is contained in column A without any
gaps. =AVERAGE(OFFSET($A$1, COUNTA($A:$A) - 10, 0, 10)) -- Rob van Gelder - http://www.vangelder.co.nz/excel "Pat" wrote in message ... I am trying to calculate a running average of the last 10 items I place in a row. Is there an easy way to do this? |
#3
|
|||
|
|||
"Rob van Gelder" wrote: Assumes your list starts in A1 and is contained in column A without any gaps. =AVERAGE(OFFSET($A$1, COUNTA($A:$A) - 10, 0, 10)) -- Rob van Gelder - http://www.vangelder.co.nz/excel "Pat" wrote in message ... I am trying to calculate a running average of the last 10 items I place in a row. Is there an easy way to do this? Rob, Thanks. What if I also want to include another column? |
#4
|
|||
|
|||
Assuming the columns are adjacent - by using the Width argument of Offset
This averages last 10 entries of columns A and B =AVERAGE(OFFSET($A$1, COUNTA($A:$A) - 10, 0, 10, 2)) -- Rob van Gelder - http://www.vangelder.co.nz/excel "Pat" wrote in message ... "Rob van Gelder" wrote: Assumes your list starts in A1 and is contained in column A without any gaps. =AVERAGE(OFFSET($A$1, COUNTA($A:$A) - 10, 0, 10)) -- Rob van Gelder - http://www.vangelder.co.nz/excel "Pat" wrote in message ... I am trying to calculate a running average of the last 10 items I place in a row. Is there an easy way to do this? Rob, Thanks. What if I also want to include another column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |