How do I write a formula that will auto start sum from the first cell with value though to the end which including blanks, and then divide the total by number of cells from the one with value through to the end(including the blanks
Jan Feb Mar April May June July Total Comment
200 10 90 50 0.6667 divide by 6 months
100 200 10 90 50 0.7143 divide by 7 months
10 90 50 0.7500 divide by 4 months
50 200 50 10 90 50 0.8571 divide by 7 months
200 10 90 50 0.6667 divide by 6 months
90 100 50 1.0000 divide by 3 months
200 90 50 1.0000 divide by 3 months
200 10 90 50 0.8000 divide by 5 months