Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #531 May 6, 2012 www.energyefficientbuild.com
user Uraku said:
Counting number of questionnaire entries
Hi guys, I've made a form with 1 question with many choices. It is put into a spreadsheet but I can't find a way to make it count how many of each entry has been voted for. Help! :(
-----------------------------------------------------------------------------------------------
user Uraku said:
Counting number of questionnaire entries
Hi guys, I've made a form with 1 question with many choices. It is put into a spreadsheet but I can't find a way to make it count how many of each entry has been voted for. Help! :(
-----------------------------------------------------------------------------------------------
I first provided a solution using the QUERY function
then Uraku indicated he was trying to use the COUNTIF function but wasn't havin success ... so I added a solution using the COUNTIF function as well.
No comments:
Post a Comment