Formula to count two different values in the same column

Options
Kelly Ospina
Kelly Ospina ✭✭✭✭✭
edited 02/03/23 in Formulas and Functions

I'm trying to create a summary field formula to count two different values in the same column. The formula seems to work, but it returns a value of "0" which I know is not correct.

=COUNTIFS(PMActivity:PMActivity, "303", PMActivity:PMActivity, "307")

Hoping someone can point out where I've gone wrong on this one.

Thank you for your help!

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!