| ITEM | POINT VALUE | YES/NO | Total |
| A | 1 | Yes | 1 |
| B | 0.5 | No | 0 |
| C | 3 | No | 0 |
| D | 2.5 | Yes | 2.5 |
Would love some assistance on a formula that could add point value's to cell (col D) depending on whether or not Yes or No (col C) is selected.
So if yes is selected, then it would add the value in col B and if No is selected then it does not add any value to col D
