What function do i use to retrieve the count from multi category?


EG: In Column #1 i have three categories:

  • Internal
  • External
  • Carrier

In Column #2 i have

  • PC
  • Phone
  • Tablet

I want to know the count for PC for internal seperate as well as the counts for external and carrier. I would like to repeat this for the phone and tablet. Any suggestions?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!