COUNTIFS for each week of the quarter
Hi, in my job we gene edit cells and afterwards, we see which percentage of the population received the edit (range 0-100%).
I am trying to track how many orders fall into which range (0,%, 1-9%, 10-19%... 90-100%) for each week of the quarter. This information is pulled from a master sheet where we keep track of all of our orders.
I have attached a picture of what the tracking sheet looks like. The portion of the formula that is relevant to my question is bolded :
Right now, I would have to go into every single cell and manually enter the date range. Is there a way to get this automated?
Essentially, I'm asking how to do a COUNTIFS with a date range. Thank you!