Variable average
 

Hi

I need a formula that will give me a daily average for rowing metres. I want to complete 100k and will enter each day my metres completed. I then need the average daily metres I need to do. The days are 24 .

Thanks

Hi,

I have something very similar for recording cycling distances month by month throughout the year.

The attached is a VERY basic version of this. I've adapted to your 100km goal over 24 days. At least I think this is what you mean.

Let me know if you need any help adapting it to your requirements. Or if it's nothing like what you're after I'm happy to help you develop something.

Spencer.

Many thanks, fantastic, above my ability

Not a problem. Glad to help.

That's a VERY basic version. If you want help developing something more indepth, or if you just need any of that version explained, reply here or drop me a PM and I'll happily help out.

S.



Also, the formula in cell H3 should be =IF(SUM(C3:C26)=0,"",SUM(C3:C26)/COUNTIF(C3:C26,"0")) to give an average of only days where you have rowed.

Sorry about that. Completely forgot to amend it in the version I posted.