Apr 25 2021 01:24 PM
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
Apr 25 2021 01:40 PM
SolutionLet's say the answers are in B2:B20.
=4*SUMPRODUCT(--(B2:B20="Yes"))+2*SUMPRODUCT(--(B2:B20="Sometimes"))
Apr 25 2021 01:40 PM
SolutionLet's say the answers are in B2:B20.
=4*SUMPRODUCT(--(B2:B20="Yes"))+2*SUMPRODUCT(--(B2:B20="Sometimes"))