How do i count if the cell is greater than my avg?

I am trying to countthe number of cells if the cell value is greater than my avg.This is the formula i try but i cant seem to figure it out" =COUNTIFS([Actual Build Length (Months) (Elliot)] > [Actual Build Length (Months) (Elliot)]1)"

Any Suggestions?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!