View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RickMoore RickMoore is offline
external usenet poster
 
Posts: 9
Default Average last 4 entries in a row.

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