CountIF not working

Paul Molloy
Paul Molloy ✭✭✭✭
edited 11/10/20 in Formulas and Functions


i am trying to count all the the number 4s and 5s wtihin a column. I am using this formula

=COUNTIF([Stage ID]:[Stage ID], =4) + =COUNTIF([Stage ID]:[Stage ID], =5)

but it does not work. the column has many 1,2,3,4,5,6 and i just want to count the 4 and 5s.

thanks for your help

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!