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

Options

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!