Link to home
Create AccountLog in
Avatar of Cactus1993
Cactus1993Flag for United States of America

asked on

Excel 2007: Calculate the Monthly Pace from a Set of Timed Runs

Just looking for a formula to calculate the average pace each month from a database of runs.

The attached spreadsheet may help.

Thanks!
EE6.xlsx
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

I hope you don't mind my posting this but if you have an iPhone you can do that and much, much more with this app.
ASKER CERTIFIED SOLUTION
Avatar of zorvek (Kevin Jones)
zorvek (Kevin Jones)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Cactus1993

ASKER

Kevin (zorvek):

Thanks -- works great.

One additional question ... what is the  "-1"  in your formula "SUMPRODUCT((MONTH(A2:A15)=ROW(E2)-1)*C2:C15)/F2)" used for?

Thanks again.
Kevin (zorvek):

Thanks -- works great.

One additional question ... what is the  "-1"  in your formula "SUMPRODUCT((MONTH(A2:A15)=ROW(E2)-1)*C2:C15)/F2)" used for?

Thanks again.
The Row(E2)-1 part is a trick for determining the month of that row (Jan=1, Feb=2, etc.) I could have done the same thing with something like MONTH("1"&E2).

Kevin
Thanks again!