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

rspengle81696

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)

Nic Larsen

Try something like this. I opened ended the ranges. 

=(((COUNTIF(G:G, ="High") * 3) + (COUNTIF(G:G, ="Moderate") * 2) + (COUNTIF(G:G, ="Low") * 1))) / COUNT(G:G)

rspengle81696

Thanks for the reply.  I think on right track with it being open ended but I still get a "#unparseable".  Very frustrating.  Any ideas?

Thanks!

rspengle81696

Got it!!!  I had an extra ) in the my formula.  Thanks again for the help!!!

Nic Larsen

Perfect, glad to help.