Dysprositos
Board Regular
- Joined
- Aug 3, 2002
- Messages
- 92
Hello all,
Im trying to return an average of the last three values in a list. The list grows as more values are added to the bottom. But id like the average to "move" as more values are added.
So far i can return the last value in the list by
=LOOKUP(9.99999999E+54,Sheet1!T:T)
But how can i add this value to the two previous values?
TIA
Im trying to return an average of the last three values in a list. The list grows as more values are added to the bottom. But id like the average to "move" as more values are added.
So far i can return the last value in the list by
=LOOKUP(9.99999999E+54,Sheet1!T:T)
But how can i add this value to the two previous values?
TIA