Forum Discussion
Solved
Value to answers on Excel
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
Let's say the answers are in B2:B20.
=4*SUMPRODUCT(--(B2:B20="Yes"))+2*SUMPRODUCT(--(B2:B20="Sometimes"))
2 Replies
Let's say the answers are in B2:B20.
=4*SUMPRODUCT(--(B2:B20="Yes"))+2*SUMPRODUCT(--(B2:B20="Sometimes"))
- Helped so much!! Thanks
