Soldato
So I have an issue I am trying to get around using Google Sheets!
I have the spreadsheet of which I made a copy of here:
https://docs.google.com/spreadsheets/d/1HmR32V34zUXkrh-25BgHUXDi6gZJBHwk_HQijHL3KD4/edit?usp=sharing
The purpose of which is to count the points gained by each class to feed into a graph.
Now the sumif function in column H works as intended - it finds the class in column C based on the criteria in column G and adds up the points awarded in column E.
So far so good.
The issue arises when I am trying to do the same for columns I, J and K
I want to be able to select a start date and an end date for the formula to count only values between those 2 dates.
For column K, I just want it to count the values for the 1 day.
Hit a bit of a mental block so any help will be appreciated!
Thanks in advance
I have the spreadsheet of which I made a copy of here:
https://docs.google.com/spreadsheets/d/1HmR32V34zUXkrh-25BgHUXDi6gZJBHwk_HQijHL3KD4/edit?usp=sharing
The purpose of which is to count the points gained by each class to feed into a graph.
Now the sumif function in column H works as intended - it finds the class in column C based on the criteria in column G and adds up the points awarded in column E.
So far so good.
The issue arises when I am trying to do the same for columns I, J and K
I want to be able to select a start date and an end date for the formula to count only values between those 2 dates.
For column K, I just want it to count the values for the 1 day.
Hit a bit of a mental block so any help will be appreciated!
Thanks in advance