I'm pretty sure I need to use the SUMIF equation to figure this out but I'm not really sure how...
I have a spreadsheet of all the running I've done throughout the year and I'd like to figure out how many 5k's I have run so far. My current spreadsheet looks like this:
<tbody>
</tbody>
<tbody>
</tbody>
I'd like to write a formula that finds all 5k/5k+ in the "D" column and adds ONE for each cell. For example, the equation should equal "3" based upon the shown spreadsheet.
I will be using this same formula to figure out Benchmark runs and 10ks in the future.
Thank you in advance!
I have a spreadsheet of all the running I've done throughout the year and I'd like to figure out how many 5k's I have run so far. My current spreadsheet looks like this:
Date | Mi | Time | Pace | |
1/1 | 0:00:00 | |||
1/2 | 3.20 | 0:26:16 | 0:08:12 | 5k |
1/3 | 1.00 | 0:07:39 | 0:07:39 | |
1/4 | 1.00 | 0:07:45 | 0:07:45 | |
1/5 | 0:00:00 | |||
1/6 | 0:00:00 | |||
1/7 | 3.20 | 0:25:55 | 0:08:06 | 5k |
1/8 | 1.63 | 0:15:20 | 0:09:24 | Benchmark |
1/9 | 1.00 | 0:07:12 | 0:07:12 | |
1/10 | 3.50 | 0:29:32 | 0:08:26 | 5k+ |
<tbody>
</tbody>
<tbody>
</tbody>
I'd like to write a formula that finds all 5k/5k+ in the "D" column and adds ONE for each cell. For example, the equation should equal "3" based upon the shown spreadsheet.
I will be using this same formula to figure out Benchmark runs and 10ks in the future.
Thank you in advance!