We have a spreadsheet of all the songs used by the show NFL Primetime (NFL Primetime Song Info Listings & by Games/Weeks/Years Used), tab 2 is Songs by Games/Weeks/Years Used, which has the songs used each year as well as the total times they were used during the season.
I'd like to know if it's possible to create a formula or something to:
- Get the count of how many seasons a song was used for all the seasons, column C (eg, song was used for 6 years, it would count each of it's instances)
- Get the full total of all the times the song was used across the whole TV series, column D (eg, using that same song, adding up the TOTs for each year used for a grand total)
I'm sure this is possible, but have no idea how to implement either. It would also be good to have something that 'validation' tested, like [if C2="SONGNAME" then count C2] or [if C2="SONGNAME" then add D2 total], I know those aren't formulas, just trying to explain what I mean, so if rows are added or edited, it won't screw up everything else.
I'd like to know if it's possible to create a formula or something to:
- Get the count of how many seasons a song was used for all the seasons, column C (eg, song was used for 6 years, it would count each of it's instances)
- Get the full total of all the times the song was used across the whole TV series, column D (eg, using that same song, adding up the TOTs for each year used for a grand total)
I'm sure this is possible, but have no idea how to implement either. It would also be good to have something that 'validation' tested, like [if C2="SONGNAME" then count C2] or [if C2="SONGNAME" then add D2 total], I know those aren't formulas, just trying to explain what I mean, so if rows are added or edited, it won't screw up everything else.
