Formaula for averaging

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I am trying to come up with a formaula to average a row
of numbers to which a new number is added at the end of
the row daily. I need to update the average without
having to go in manually add the cell containing the new
value to the average formula. Is there a way to
calculate =Average(2D: last entered number?). With "the
last entered number" updating automatically? I need the
average in Column A.

1 A B C D E F G H I J
2 =Avg Text Text 10 15 3
3 =Avg Text Text 12 11 9
 
Is it possible to write a formula which would give me the
average of every other cell in the same situation (ie
values in columns d,f,h,i,etc)?

Heather
 
One possible way

=AVERAGE(IF(MOD(COLUMN(OFFSET($D$2,,,,COUNTA(D2:IV2))),2)=0,OFFSET($D$2,,,,C
OUNTA(D2:IV2))))

entered with ctrl + shift & enter
 
Back
Top