I have a spreadsheet in which there are yes and no question, I want to add a specific value to each yes and no answer. How can I do that? I added =COUNTIFS(J2,"yes") but this gives me a value of 1 for Yes and 0 for No.