Complex COUNTIFS and IF Function


I need help putting together a function that can count certain cells in my grid. The inputs of the function are the following:

  • If Beta is "Yes", it should be counted twice
  • If Beta is "No", it should be counted once
  • But if the Primary Region Column is not checked, the row should not be counted at all.

Beta is a column with only yes or no selectable answers, Primary Region is another column that is a checkbox.

I need the total sum of how this is added up after these inputs are accounted for, is this doable?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!