Using Countifs where column data is never the same


Trying to use a Countif formula to track a column of data, but the data in each cell is always different. Attaching a snippet of some of the data from that column. Some data does repeat, but for the most part, the column data would always be different, unlike a dropdown list. What would be the best approach to use count these "Key Products"?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!