Countifs formula to count a value within a date range?
Our company has ongoing surveys and the raw data is organized by different dates (dates the survey was complete). We want to only count the cells for a particular date range in our calculations sheet to give us the survey results for that time frame.
For example: I only want smartsheet to look at the surveys completed between 1/1/2021 and 12/31/2021 and within that, only look at the values that equal "5" for a particular question (column).
Would this be a countifs formula? If so, how would it be structured? The goal is some sort of automation as more surveys are completed.
Help Article Resources
Check out the Formula Handbook template!