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