SUMIFS I think?

I am trying to count a total number of employees in a multi-select drop down and also only count those employees if they attended meetings in November, December, January, Etc. All of this data is absorbed via a form.

My current formula is:

=SUMIFS([Employees at meeting]:[Employees at meeting], >1, Date:Date, AND(@cell >= DATE(2021, 11, 1), @cell <= DATE(2021, 11, 31)))

If I run a COUNTIFS, my returned amount is "1", showing their is a submission, but not counting the number of selections in the multi-select cell:

=COUNTIFS([Employees at meeting]:[Employees at meeting], >1, Date:Date, AND(@cell >= DATE(2021, 11, 1), @cell <= DATE(2021, 11, 31)))

I am trying to produce this in a sheet summary on the right hand side.

What am I missing here?

Kyle

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!