I have 20 numbers in a row (G34:Z34) I would like to average the last 5
entries. So if I have 10 entries (G34:P34),I would only like to average
(L34:P34) Which is the last 5 entered and continue on averaging the last 5
all the way to (Z34).
--
Geo
I have 20 numbers in a row (G34:Z34) I would like to average the last 5
entries. So if I have 10 entries (G34:P34),I would only like to average
(L34:P34) Which is the last 5 entered and continue on averaging the last 5
all the way to (Z34).
--
Geo
If there are no blank cells in-between you can use
=AVERAGE(OFFSET($G$34,,COUNT($G$34:$Z$34)-1,,-5))
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"Geo" <[email protected]> wrote in message
news:[email protected]...
>I have 20 numbers in a row (G34:Z34) I would like to average the last 5
> entries. So if I have 10 entries (G34:P34),I would only like to average
> (L34:P34) Which is the last 5 entered and continue on averaging the last
> 5
> all the way to (Z34).
> --
> Geo
One way:
=AVERAGE(OFFSET(G34,0,COUNTA(G34:Z34)-5,1,5))
In article <[email protected]>,
Geo <[email protected]> wrote:
> I have 20 numbers in a row (G34:Z34) I would like to average the last 5
> entries. So if I have 10 entries (G34:P34),I would only like to average
> (L34:P34) Which is the last 5 entered and continue on averaging the last 5
> all the way to (Z34).
Geo,
In cell Q34, add the formula "=average(L34:P34)". Then copy that formula
across the range R34:Z34.
----
Regards,
John Mansfield
http://www.pdbook.com
"Geo" wrote:
> I have 20 numbers in a row (G34:Z34) I would like to average the last 5
> entries. So if I have 10 entries (G34:P34),I would only like to average
> (L34:P34) Which is the last 5 entered and continue on averaging the last 5
> all the way to (Z34).
> --
> Geo
What is wrong with the answers given in your previous posting?
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Geo" <[email protected]> wrote in message
news:[email protected]...
> I have 20 numbers in a row (G34:Z34) I would like to average the last 5
> entries. So if I have 10 entries (G34:P34),I would only like to average
> (L34:P34) Which is the last 5 entered and continue on averaging the last
5
> all the way to (Z34).
> --
> Geo
Just to make sure he posted again a third time and wasted Ken Wright's time
as well as
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> What is wrong with the answers given in your previous posting?
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Geo" <[email protected]> wrote in message
> news:[email protected]...
>> I have 20 numbers in a row (G34:Z34) I would like to average the last 5
>> entries. So if I have 10 entries (G34:P34),I would only like to average
>> (L34:P34) Which is the last 5 entered and continue on averaging the last
> 5
>> all the way to (Z34).
>> --
>> Geo
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks