from what i have been reading online it appears Countifs function is what i need to use for my problem. I have data that looks like this and goes on for several months:
|Month |Day| Time |Value | May |1 |7:30 AM - 9:30 AM |2 | May |1 |9:30 AM - 12:30 PM|2 | May |1 |12:30 PM -3:00 PM |2 | May |1 |3:00 PM - 5:30 PM |1 | May |1 |5:30PM - 7:00 PM |3 | May |1 |7:00 PM - 11:00 PM|1
for each month, I want it to count how many times the value is 1 for each time interval, 2 for each time interval and 3 for each time interval. it seems that countifs is appropriate for the logic of doing this. Ive never used countifs and I am unsure how to write it, if countifs is the right function.