Variable average

[Haiggy]

Hi

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

Thank

 

[Spencer101]

Hi

I need a formula that will give me a daily average for rowing metres.
want to complete 100k and will enter each day my metres completed.
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 b
month throughout the year.

The attached is a VERY basic version of this. I've adapted to you
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. O
if it's nothing like what you're after I'm happy to help you develo
something.

Spencer

+-------------------------------------------------------------------
|Filename: Rowing.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=703
+-------------------------------------------------------------------

 

[Haiggy]

Many thanks, fantastic, above my abilit

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Spencer101]

Many thanks, fantastic, above my ability

Not a problem. Glad to help.

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

S.



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

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

+-------------------------------------------------------------------
+-------------------------------------------------------------------