Averaging the last 5 entries in a row
 

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" wrote in message
...
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 ,
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,

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" wrote in message
...
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" wrote in message
...
What is wrong with the answers given in your previous posting?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Geo" wrote in message
...
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