# Need help making a formula

✭✭✭

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

• ✭✭✭✭✭

Are the participants listed in a multi-select dropdown cell?

• ✭✭✭

@Austin Smith No they are not. It is a text box and the facilitators simple type in the number when they fill out the form.

• ✭✭✭✭✭

Try this:

=sumifs([number of participants]:[number of participants], [Range 1], "DiSC", [Range 2], "1")

• ✭✭✭✭✭✭

Hi @mrseibt - You'll need to use SUMIFS to add up the participants. You'll need to create a reference to your participants column. Give this a try!

`=SUMIFS({Number of Participants Column}, {Assessment Tracker Sheet Range 1}, "DiSC", {Assessment Tracker Range 2}, "1")`

Please let me know if this works for you!

Amber Eakin, MSLS, M.Ed.

Adult Education Specialist | Process Improvement Enthusiast

• ✭✭✭

Thank you @Austin Smith and @Amber Eakin ! This did what I needed it to do. Since I’m new to using formulas, any suggestions on where to learn tips and tricks that a beginner can understand? Besides trial and error.

• ✭✭✭✭✭✭

Absolutely! There are tutorials, and you could use Smartsheet University if you have access.

Amber Eakin, MSLS, M.Ed.

Adult Education Specialist | Process Improvement Enthusiast

• ✭✭✭✭✭✭

Hi @mrseibt

I hope you're well and safe!

This is an excellent resource to play around with.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭

Create a new sheet using templates and search for "formula", there's a formula handbook that Smartsheet's written to help. Outside of that, searching through the Community here is pretty helpful. Typically you won't be the only one with the problem you're looking for an answer to.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!