Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using the OFFSET and COUNT functions to get a moving total
I am currently using the following formula:
=OFFSET(D10,COUNT(D11:D202),0). This inserts in a cell the value of the last item in column D. What I am trying to figgure out is how to get the total of the last 12 enteries in column D. ie. as each new value is entered into that column, it should automaticaly calculate the total of the last 12 values. Thanks, Eduardo |
#2
|
|||
|
|||
Using the OFFSET and COUNT functions to get a moving total
Hi!
Assuming that there are no empty cells within the range: =SUM(OFFSET(D10,COUNT(D11:D202),,-12)) Biff "Eduardo" wrote in message oups.com... I am currently using the following formula: =OFFSET(D10,COUNT(D11:D202),0). This inserts in a cell the value of the last item in column D. What I am trying to figgure out is how to get the total of the last 12 enteries in column D. ie. as each new value is entered into that column, it should automaticaly calculate the total of the last 12 values. Thanks, Eduardo |
#3
|
|||
|
|||
Using the OFFSET and COUNT functions to get a moving total
Thanks, it worked. Eduardo
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|