Google Spreadsheet Count IF contains a string

Question

I have a column like this    What devices will you be using    iPad Kindle  amp  iPad No Tablet iPad iPad  amp  Windows   How do I count the amount of people that said iPad   This formula does work for exact matches but not if it contains an additional value      COUNTIF A2 A51   iPad   COUNTA A2 A51   1   Any Suggestions

User · Answer

Wildcards worked for me when the string I was searching for could be entered manually. However, I wanted to store this string in another cell and refer to it. I couldn't figure out how to do this with wildcards so I ended up doing the following:

A1 is the cell containing my search string. B and C are the columns within which I want to count the number of instances of A1, including within strings:

=COUNTIF(ARRAYFORMULA(ISNUMBER(SEARCH(A1, B:C))), TRUE)

User · Answer

In case someone is still looking for the answer  this worked for me   COUNTIF A2 A51   quot   quot   amp  B1  amp   quot   quot    B1 containing the iPad string

User · Answer

Try using wildcards directly in the COUNTIF function       COUNTIF A2 A51    iPad    COUNTA A2 A51   1

User · Answer

You should use    COUNTIF A2 A51    iPad    COUNTA A2 A51   Additionally  if you wanted to count more than one element  like iPads OR Kindles  you would use    SUM COUNTIF A2 A51     iPad      kindle      COUNTA A2 A51   in the numerator

User · Answer

It will likely have been solved by now  but I ran accross this and figured to give my input   COUNTIF a2 a51   iPad      The important thing is that separating parameters in google docs is using a   and not a

User · Answer

Try just  COUNTIF A2 A51  iPad

[google-sheets] Google Spreadsheet, Count IF contains a string

Examples related to google-sheets

Examples related to wildcard