This formula appears to work for less that 4 entries, but it averages all the
entries in the row if there are more than 4. I copied the formula from your
reply, so I am pretty sure it is entered it properly. Thanks for you help!
--
Rick


"RagDyeR" wrote:

This formula will average the last 4 entries, *BUT*, will also average
entries that are less then 4, if 4 are not present.

=AVERAGE(INDEX(C4:AB4,INDEX(LARGE(ISNUMBER(C4:AB4) *COLUMN(C4:AB4),4),0)):AB4)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"RickMoore" wrote in message
...
I have a row of data that I would like to have a formula that will average
the last 4 cell at have entries. The data is continually added to
The data is in cells C4:AB4
The formula will be in cell AC4
There can be less than 4 entries
There can be blank cell
There are no zeros
--
Rick