Sunday, May 6, 2012

yogi_Count Number Of Entities In A Column Using Function QUERY As Well As COUNTIF Function

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #531    May 6, 2012

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.