countifs formula help!

Hey! So I have 17 sheets that I need to pull data from. Each sheet is a form that an employee uses to fill out a survey. Each employee is required to fill out 4 surveys a month. I need to create a sheet that references those survey sheets and tally up how many surveys that employee completed each month. For instance July, August, Sept. Our previous excel doc used the countifs and referenced a date table we changed monthly for the correct counts. How can I do this in Smartsheets? Here is the formula I am trying to use that doesn't work. I am referencing the other sheet



Answers