Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Quote:
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. |
#3
|
|||
|
|||
Many thanks, fantastic, above my ability
|
#4
|
|||
|
|||
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. Last edited by Spencer101 : December 3rd 12 at 10:40 AM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
variable average | Excel Discussion (Misc queries) | |||
Average the last eight or nine (Variable) numbers in a row. | Excel Discussion (Misc queries) | |||
How to average one constant # to variable #s? A1:A2 A1:A3 A1:A4 | Excel Worksheet Functions | |||
average last 17 cells (variable) | New Users to Excel | |||
average last 17 cells (variable) | New Users to Excel |