We help IT Professionals succeed at work.

Excel: Need Total Number of Runs

In the attached, I need a formula to determine the number of runs, that corresponds with the total number of miles run, for each week.

Thanks. EE-Count.xlsx
Comment
Watch Question

I am not sure if this formula works for you. But if you give more explanation, we might give you the formula you want. Put the formula below in E2 and copy down.

=ROUND(D2/B2,0)

Sincerely,
Ed
Top Expert 2008
Commented:
=COUNTIFS($A:$A,">="&$C2,$A:$A,"<"&C2+7)

Thomas
Cactus1993Owner

Author

Commented:
Nutsch:

Nailed it.

Thanks!
Top Expert 2008

Commented:
Glad to help. Thanks for the grade.

Thomas