Soldato
Joined
25 Oct 2014
Posts
3,064
Location
East of the Middle
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
 
Back
Top Bottom