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     www.energyefficientbuild.com.   Dec-24, 2013
question by Ramunas Kulvelis (http://productforums.google.com/forum/?zx=f7xjnk7yqcml#!category-topic/docs/spreadsheets/UQlnpEOgBGo)
Having difficulty in using countif
Hello,

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

https://docs.google.com/spreadsheet/pub?key=0AnZThc8kqc3vdElydVo2bEhEZzZJd0JsMU5YSzhmaWc&single=true&gid=2&output=html

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. 

-------------------------------------------------------------------------------------------------------------------------

No comments:

Post a Comment