I need to count the number of roles where either Capital or Expense > 0 (so if Cap+Exp > 0 then count it)
I am having difficulty with the equation portion
<colgroup><col><col span="2"><col span="3"></colgroup><tbody>
</tbody>
I am having difficulty with the equation portion
A | B | C | |||
1 | Role | Capital | Expense | ||
2 | PM | $ 4,500 | $ 2,500 | ||
3 | BA | $ - | $ 1,000 | ||
4 | Testing | $ 10,000 | $ - | ||
5 | Dev | $ - | $ - | ||
6 | PM | $ - | $ 10,000 | ||
7 | Dev | $ 1,000 | $ - | ||
8 | |||||
9 | |||||
10 | Expected Results | ||||
11 | PM | 2 | |||
12 | BA | 1 | |||
13 | Testing | 1 | |||
14 | Dev | 1 | |||
If (Capital + Expense) > 0 then count it |
<colgroup><col><col span="2"><col span="3"></colgroup><tbody>
</tbody>