SOLVED

Value to answers on Excel

New Contributor

Hello - and thanks to whoever helps!

 

I've collected answers in the form of a questionnaire on Google forms, and now I have them on an Excel document. I'm trying to attribute a value to each answer (Yes = 4, Sometimes = 2, No = 0) and have them added at the end of each individual submission of the questionnaire - but I have not succeded.

Can someone help?

Thanks

2 Replies
best response confirmed by RSS96 (New Contributor)
Solution

@RSS96 

Let's say the answers are in B2:B20.

 

=4*SUMPRODUCT(--(B2:B20="Yes"))+2*SUMPRODUCT(--(B2:B20="Sometimes"))

Helped so much!! Thanks