Need help making a formula

Options

I'm new to Smartsheet and bad at formulas. I need help creating a formula for the below data.

I need to count the total number of participants, for each specific assessment type, i.e. DiSC, when they fall into the specific session month, i.e "2" I've used the below formula to count the number of times the assessment has appeared in each session month, but I don't know how to add in the participants to total them up.

=COUNTIFS({Assessment Tracker Sheet Range 1}, "DiSC", {Assessment Tracker Range 2}, "1")

Range 1= Assessment type

Range 2= Session Month

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!