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= 0AnZThc8kqc3vdElydVo2bEhEZzZJd 0JsMU5YSzhmaWc&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.
-------------------------------------------------------------------------------------------------------------------------
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/
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