Cactus1993

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

The attached spreadsheet may help.

Thanks!

EE6.xlsx

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

membership

Create an account to see this answer

Signing up is free. No credit card required.

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.

Thanks -- works great.

One additional question ... what is the "-1" in your formula "SUMPRODUCT((MONTH(A2:A15)

Thanks again.

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.

Thanks -- works great.

One additional question ... what is the "-1" in your formula "SUMPRODUCT((MONTH(A2:A15)

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

Kevin

ASKER

Thanks again!