Basic Formula | HELP |

Occasional Contributor
ITEMPOINT VALUEYES/NOTotal
A1Yes1
B0.5No0
C3No0
D2.5Yes2.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

3 Replies

@BettaB97 

Perhaps

=[@[Point Value]*( [@Yes/No]="Yes" )
Gives me Parse Error

Sorry I am not very good at excel at all and still learning

@BettaB97 

That could be like

image.png

and drag it down.