Is there a formula to count multiple items in the same column?


Hi! I am trying to create a sheet summary that counts multiple items in one column. for example: =COUNTIFS([policy_name]:[policy_name], "package B", [policy_name]:[policy_name], "Package C") but it gives me 0. Is there a way to count multiple items within the same column?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!