Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Variable average
6 views
Skip to first unread message
Haiggy
Dec 1, 2012, 4:45:56 AM12/1/12
to
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
--
Haiggy
Spencer101
Dec 1, 2012, 2:01:38 PM12/1/12
to
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.
+-------------------------------------------------------------------+
|Filename: Rowing.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=703|
+-------------------------------------------------------------------+
--
Spencer101
Haiggy
Dec 3, 2012, 5:34:35 AM12/3/12
to
Many thanks, fantastic, above my ability
+-------------------------------------------------------------------+
+-------------------------------------------------------------------+
--
Haiggy
Spencer101
Dec 3, 2012, 5:37:00 AM12/3/12
to
Haiggy;1607791 Wrote:
> Many thanks, fantastic, above my ability
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.
+-------------------------------------------------------------------+
+-------------------------------------------------------------------+
--
Spencer101
0 new messages