Spreadsheet: 767996d1644777964-working-if-and-sumproduct-function-but-now-need-to-ignore-empty-cells-if-sumproduct-example
Sheet: All Completed VC

MY parkrun VOLUNTEERING - ALL COMPLETED CREDITS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RETURN TO CONTENTS & INSTRUCTIONS / GUIDE
All of my parkrun [NAME], including all information / data / calculations. The majority of the other worksheets, in this section, use this worksheet to calculate.
Stint # | Event (Venue) Run # | Event (Venue) | Country | Role | Date Completed | First Timer? | Age Group | Primary Group (Club) | Home Page Link | Course Page Link | Weekday Completed | Day Completed | Month Completed (Numeric) | Day / Month Completed | Year Completed | Date Lookup | Season Completed | Event (Venue) Credit # | First Instance of Event (Venue) | First Instance of Event (Venue) Date | Tourist Streak # | New Year's Day Double | New Year's Day Double Date | New Year's Day Double Event (Venue) #1 | New Year's Day Double Event (Venue) #2 | New Year's Day Double Events (Venues) #1 and #2 | New Year's Day Double Events (Venues) #1 and #2 on Date | Obsessive Annual Stint # | Obsessive Annual Stint # in Year | Latitude (Decimal Degrees) | Longitude ([NAME]) | Latitude, [NAME] ([NAME]) | Country - Prinicpality etc. | Country / Prinicpality etc. | County | Traditional County | Arbitrary Region (Leave as Region, if No Change) | Region | Event (Venue) Short Name | Distance from Home parkrun (K) | Distance from Home parkrun ([NAME]) | Distance from Average parkrun Volunteering Stint Latitude / Longitude ([NAME]) (K) | Distance from Average parkrun Volunteering Stint Latitude / Longitude ([NAME]) ([NAME]) | Latitude of Home parkrun, at the Time (Decimal Degrees) | Longitude of Home parkrun, at the Time (Decimal Degrees) | Distance from Home parkrun, at the Time (K) | Distance from Home parkrun, at the Time (Miles) | Role Stint # | Notes | Credit # | First Instance of Role at Event (Venue)? | Unique Role # at Event (Venue) | Unique Role Credit # at Event (Venue) | Alphabetourist Letter | First Instance of Alphabetourist Letter | Alphabetourist Letter Count | Cumulative Alphabeteer # | First Instance of Date at Event (Venue)? | First Instance of Date Event (Venue) | First Instance of Date Country | First Instance of Date Date | First Instance of Date Event (Venue) & Date | First Instance of Occasion Cumulative # | Note Cumulative # | Obsessive Annual Occasion Year | Consecutive Different Event (Venue) Streak #
1 | 419 | Newport parkrun | United Kingdom | Marshal | 2019-03-30 00:00:00 | 1 | VM35-39 | LLISWERRY RUNNERS | https://https://www.parkrun.org.uk/newport | https://https://www.parkrun.org.uk/newport/course | Saturday | 1900-01-30 00:00:00 | 3 | 30/03 | 2019 | 3003 | Spring | 1 | Newport parkrun | 2019-03-30 00:00:00 | 1 |  |  |  |  |  |  | 1 | 1 in 2019 | 51.559479 | -3.030939 | 51.559479, -3.030939 | United Kingdom - Wales | Wales | Newport | Gwent | Severn Estuary-ish | South Wales | Wales | Newport | 8.411923151363395 | 5.226926717571503 | 3.172307708727582 | 1.971180623115743 | 51.559479 | -3.030939 | 0 | 0 | 1 | First ever parkrun volunteering credit! | 1 | 1 | 1 | 1 | N | N | N1 | 1 | 1 | Newport parkrun | United Kingdom | 2019-03-30 00:00:00 | Newport parkrun (30/03/2019) | 1 | 1 | 2019 |  | 1
2 | 285 | Newport junior parkrun | United Kingdom | Marshal | 2019-12-22 00:00:00 | 1 | VM35-39 | LLISWERRY RUNNERS | https://https://www.parkrun.org.uk/newport-juniors | https://https://www.parkrun.org.uk/newport-juniors/course | Sunday | 1900-01-22 00:00:00 | 12 | 22/12 | 2019 | 2212 | Winter | 1 | Newport junior parkrun | 2019-12-22 00:00:00 | 2 |  |  |  |  |  |  | 2 | 2 in 2019 | 51.562767 | -3.028793 | 51.562767, -3.028793 | United Kingdom - Wales | Wales | Newport | Gwent | South Wales |  | Newport juniors | 8.398470017672754 | 5.218567327850822 | 3.149874900290994 | 1.957241522192268 | 51.559479 | -3.030939 | 0.394559184730217 | 0.2451677110240054 | 2 |  | 2 | 1 | 1 | 1 | N | N | N2 | 1 | 1 | Newport junior parkrun | United Kingdom | 2019-12-22 00:00:00 | Newport junior parkrun (22/12/2019) | 2 |  | 2019 |  | 2
3 | 1 | Coed Cefn-pwll-du parkrun | United Kingdom | Finish Token Support | 2020-01-18 00:00:00 | 1 | VM35-39 | LLISWERRY RUNNERS | https://https://www.parkrun.org.uk/coedcefnpwlldu | https://https://www.parkrun.org.uk/coedcefnpwlldu/course | Saturday | 1900-01-18 00:00:00 | 1 | 18/01 | 2020 | 1801 | Winter | 1 | Coed Cefn-pwll-du parkrun | 2020-01-18 00:00:00 | 3 |  |  |  |  |  |  | 1 | 1 in 2020 | 51.591855 | -3.140954 | 51.591855, -3.140954 | United Kingdom - Wales | Wales | Caerphilly | Gwent | Severn Estuary-ish | South Wales | Wales | Coed Cefn-pwll-du | 0 | 0 | 5.249257038932312 | 3.261737104641588 | 51.591855 | -3.140954 | 0 | 0 | 1 |  | 3 | 1 | 1 | 1 | C | C | C1 | 2 | 1 | Coed Cefn-pwll-du parkrun | United Kingdom | 2020-01-18 00:00:00 | Coed Cefn-pwll-du parkrun (18/01/2020) | 3 |  | 2020 |  | 3
4 | 6 | Coed Cefn-pwll-du parkrun | United Kingdom | Pre-Event Setup | 2020-02-29 00:00:00 |  | VM35-39 | LLISWERRY RUNNERS | https://https://www.parkrun.org.uk/coedcefnpwlldu | https://https://www.parkrun.org.uk/coedcefnpwlldu/course | Saturday | 1900-01-29 00:00:00 | 2 | 29/02 | 2020 | 2902 | Winter | 2 |  |  | 1 |  |  |  |  |  |  | 2 | 2 in 2020 | 51.591855 | -3.140954 | 51.591855, -3.140954 | United Kingdom - Wales | Wales | Caerphilly | Gwent | Severn Estuary-ish | South Wales | Wales | Coed Cefn-pwll-du | 0 | 0 | 5.249257038932312 | 3.261737104641588 | 51.591855 | -3.140954 | 0 | 0 | 1 |  | 4 | 1 | 1 | 1 | C |  |  | 2 | 1 | Coed Cefn-pwll-du parkrun | United Kingdom | 2020-02-29 00:00:00 | Coed Cefn-pwll-du parkrun (29/02/2020) | 4 |  | 2020 |  | 1
5 | 294 | Newport junior parkrun | United Kingdom | Marshal | 2021-08-29 00:00:00 |  | VM35-39 | LLISWERRY RUNNERS | https://https://www.parkrun.org.uk/newport-juniors | https://https://www.parkrun.org.uk/newport-juniors/course | Sunday | 1900-01-29 00:00:00 | 8 | 29/08 | 2021 | 2908 | Summer | 2 |  |  | 2 |  |  |  |  |  |  | 1 | 1 in 2021 | 51.562767 | -3.028793 | 51.562767, -3.028793 | United Kingdom - Wales | Wales | Newport | Gwent | South Wales |  | Newport juniors | 8.398470017672754 | 5.218567327850822 | 3.149874900290994 | 1.957241522192268 | 51.591855 | -3.140954 | 8.398470017672754 | 5.218567327850822 | 3 | First parkrun volunteering credit since suspension, due to the COVID-19 pandemic! | 5 |  |  | 2 | N |  |  | 2 | 1 | Newport junior parkrun | United Kingdom | 2021-08-29 00:00:00 | Newport junior parkrun (29/08/2021) | 5 | 2 | 2021 |  | 2
6 | 294 | Newport junior parkrun | United Kingdom | Photographer | 2021-08-29 00:00:00 |  | VM35-39 | LLISWERRY RUNNERS | https://https://www.parkrun.org.uk/newport-juniors | https://https://www.parkrun.org.uk/newport-juniors/course | Sunday | 1900-01-29 00:00:00 | 8 | 29/08 | 2021 | 2908 | Summer | 3 |  |  | 1 |  |  |  |  |  |  | 2 | 2 in 2021 | 51.562767 | -3.028793 | 51.562767, -3.028793 | United Kingdom - Wales | Wales | Newport | Gwent | South Wales |  | Newport juniors | 8.398470017672754 | 5.218567327850822 | 3.149874900290994 | 1.957241522192268 | 51.591855 | -3.140954 | 8.398470017672754 | 5.218567327850822 | 1 | First parkrun volunteering credit since suspension, due to the COVID-19 pandemic! | 5 | 1 | 1 | 1 | N |  |  | 2 |  |  |  |  |  |  | 3 |  |  | 2
7 | 294 | Newport junior parkrun | United Kingdom | Pre-Event Setup | 2021-08-29 00:00:00 |  | VM35-39 | LLISWERRY RUNNERS | https://https://www.parkrun.org.uk/newport-juniors | https://https://www.parkrun.org.uk/newport-juniors/course | Sunday | 1900-01-29 00:00:00 | 8 | 29/08 | 2021 | 2908 | Summer | 4 |  |  | 1 |  |  |  |  |  |  | 3 | 3 in 2021 | 51.562767 | -3.028793 | 51.562767, -3.028793 | United Kingdom - Wales | Wales | Newport | Gwent | South Wales |  | Newport juniors | 8.398470017672754 | 5.218567327850822 | 3.149874900290994 | 1.957241522192268 | 51.591855 | -3.140954 | 8.398470017672754 | 5.218567327850822 | 2 | First parkrun volunteering credit since suspension, due to the COVID-19 pandemic! | 5 | 1 | 1 | 1 | N |  |  | 2 |  |  |  |  |  |  | 4 |  |  | 2
8 | 9 | Coed Cefn-pwll-du parkrun | United Kingdom | [NAME] | 2021-09-18 00:00:00 |  | VM35-39 | LLISWERRY RUNNERS | https://https://www.parkrun.org.uk/coedcefnpwlldu | https://https://www.parkrun.org.uk/coedcefnpwlldu/course | Saturday | 1900-01-18 00:00:00 | 9 | 18/09 | 2021 | 1809 | Autumn | 3 |  |  | 2 |  |  |  |  |  |  | 4 | 4 in 2021 | 51.591855 | -3.140954 | 51.591855, -3.140954 | United Kingdom - Wales | Wales | Caerphilly | Gwent | Severn Estuary-ish | South Wales | Wales | Coed Cefn-pwll-du | 0 | 0 | 5.249257038932312 | 3.261737104641588 | 51.591855 | -3.140954 | 0 | 0 | 1 |  | 6 | 1 | 1 | 1 | C |  |  | 2 | 1 | Coed Cefn-pwll-du parkrun | United Kingdom | 2021-09-18 00:00:00 | Coed Cefn-pwll-du parkrun (18/09/2021) | 6 |  | 2021 |  | 1