Monday, December 23, 2013

yogi_Count Instances Of Each Option From Comma Separated Values In Column A

                                          Google Spreadsheet   Post  #1443
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Dec-24, 2013
question by Ramunas Kulvelis (!category-topic/docs/spreadsheets/UQlnpEOgBGo)
Having difficulty in using countif

I'm having issue in utilizing COUNTIF. I use it to get the count of data that meets the criteria.

Posted a link with sheet with test data. As you can see there are cells that have data separated with commas, this is the format in what I get data from google form. COUNTIF ignores it and passes check over to next cell below, which holds only one number. The forluma I'm using is =COUNTIF($A$16:$A$24;"="&A4). Is there a way to make formula to not ignore cells with multiply data separated with commas.

Thank you.