I need to know how to average the last 7 entries, or the last 14 entries, or the last n entries in a column with many dozens of rows. There is a new entry in the column each day, so it would be a moving average.
Thanks for any help.
I need to know how to average the last 7 entries, or the last 14 entries, or the last n entries in a column with many dozens of rows. There is a new entry in the column each day, so it would be a moving average.
Thanks for any help.
Try this:
$A$1=222
$A$2=333
$A$3=444
$A$4=555
$A$5=666
$A$6=777
$A$7=888
$A$8=999
$A$9=1111
$A$10=2222
$A$11=999
$A$12=887
$A$13=886
$A$14=555
B1 = =COUNT($A:$A)
B2 = =B1-7
C1= ="A"&B1
C2= ="A"&B2
D1= =C1&":"&C2
E1= =AVERAGE(INDIRECT(D1))
RESULT IN E1 SHOULD BE 1068.375
Originally Posted by cheshajim
Thanks, Captain. This works and I've learned a little more about Excel. I guess that's what it's all about.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks