I am want to figure out the formula to average the weekly weight when the cells contain the day(as text) and the weight would entered after it. Below is an example: [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 905"]
I would also like for it to show the average even is some of the weight has not been entered on some of the days. The weight will always be the last 5 characters counting the decimal point.
I did come up with the following but i was hoping for something simpler and also be able to show avg even when a weight was not yet entered.
Thanks for your help.