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