Formula for dividing 2 columns then multiply by 12

I am trying to get the average for a specific category (Column 1), by dividing YTD Terms (Column 2) by YTD Headcount (Column 3) then multiply by 12 for my Column 1?

Here is the formula I am trying and I get Unparseable.

=COUNTIFS({Turnover ratio by Dept July 2020_YTD Term}, /{Turnover ratio by Dept July 2020_Average Employees}12*, {Turnover ratio by Dept July 2020_Department}, "Provider")


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!