Need Formula to count if cell values are Greater than 0.5

I have tried several different formulas to determine how many cells have a value greater than 0.5.  The cells are qtr 1, qtr2, qtr3, qtr4, qtr5, qtr6, qtr7, and qtr8.  The cells are not next to each other so it can not be a range.  Any suggesstions?

 

Forrest

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!