Average code advice

[ipbr21054]

Hi,
Being a Diabetic i use excel to plot my readings every day.

I am looking to get an average reading as i enter my values each day.
Please can you advise a code to achieve this.

Cell range would be B25:AF25

At present there are only figures up to J25 being 9th of this month.
So in cell D23 would be the current average value shown.

As i then enter tomorrows reading into the next cell being K25 i would like cell D23 to take this into account & show me the new reading.

Thanks

 

[ipbr21054]

Hi,

I have the idea in my head of the following,

Cell B25 150 = 150

Cell C25 100 + B25 150 / 2 = 125

Cell D25 130 + C25 100 + B25 150 / 3 = 126.6

But cant put it onto paper.


Thanks

 

[arthurbr]

Perhaps=AVERAGE(B25:INDEX(B25:AF25,match(9.99999999E307,B25:A25)))

 

[ipbr21054]

Hi,
The sum is incorrect & when i enter tomorrows figure into the next cell the average box in cell D23 does not update.

If i add up the 9 readings so far then divide that total by 9 i get 163.5 but the code shown above returns 175.5

Tomorrow the sum would be to add up the 10 readings then divide by 10

 

[LloydFinancials]

I might be missing something, but why not
=AVERAGE(B25:AF25)

 

[ipbr21054]

Hi,
You are spot on and works very nice thanks.

Ccan i ask you a question please.
If all the cells are empty & awaiting the first result can the cell in D23 shown nothing at all etc ?

Currently i see #####

Many Thanks