Countif - Want to count number of times a word appears, multiple then divide by a certain number

rspengle81696 ✭✭
edited 12/09/19 in Formulas and Functions

I'm creating a pricing sheet and need to use the countif formula.  I am counting the number of times "High", "Moderate", "Low" appears in the column and times by 3, 2 or 1  then dividing it by the total count.

For the sake of space, I named my column "G".  Not sure if Smartsheet recognizes the "+" in the formula

((COUNTIF(G10:G32, "high") * 3), + (COUNTIF(G10:G32, "moderate") * 2), + (COUNTIF(G10:G32, "low") * 1)) / COUNT(G11:G32)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!