Counting, by years

[ollyhughes1982]

Hi,

Please see attached link, where I am trying to solve my last query relating to my parkrun spreadsheet. This one is essentially 4 separate worksheets but all doing essentially the same calculation, but for different amounts:

- In the ‘All Completed Runs - B Obs’ worksheet ('Bronze Obsessive'), I want to record all years (and the total amount) where I have done 30-39 parkruns in the year

- In the ‘All Completed Runs - S Obs’ worksheet ('Silver Obsessive'), I want to record all years (and the total amount) where I have done 40-49 parkruns in the year

- In the ‘All Completed Runs - G Obs’ worksheet ('Gold Obsessive'), I want to record all years (and the total amount) where I have done 50-54 parkruns in the year

- In the ‘All Completed Runs - P Obs’ worksheet ('Platinum Obsessive'), I want to record all years (and the total amount) where I have done 55+ parkruns in the year

I have manually entered in the data, so you can see what should be populated.

Link: parkrun - My parkrun Record (Obsessives).xlsx

Thanks!

 

[Fluff]

And in B83
=SUM('All Completed Runs - TOR'!B3#)/100

 

[ollyhughes1982]

Thanks, that one worked great

 

[ollyhughes1982]

That's all of them fixed except for the Obsessive ones. Thanks

 

[Fluff]

How about
=COUNTIF('All Completed Runs - G Obs'!A3#,"<>None")

 

[ollyhughes1982]

Great. Thank you, once again. You’ve been such a great help ??

 

[Fluff]

My pleasure & thanks for the feedback