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?
Help Article Resources
Check out the Formula Handbook template!