CODEWITHSUNDEEP
excelgoogle-sheetscountif
ARPS
ARPS

Reputation: 15

Count cells that match and do not match some strings

I have a google form feeding data into a spreadsheet and I'm trying to count responses based on string text. The possible responses in a column are - "Yes. I love this" - "No. I hate it" - Random text

The third option is when response is neutral and people are free to fill i whatever they like. I have this formula counting Yes's and No's.

=countif(F3:F35,"Yes. I love this") & " Yes, " & countif(F3:F35,"No. I hate it") & " No"

What formula can I use for counting all other non-empty cells that aren't Yes or No?

Upvotes: 0

Views: 197

Answers (3)

Gary's Student
Gary's Student

Reputation: 96753

Starting with the total, remove:

  1. blanks
  2. yes's
  3. no's


=33-COUNTBLANK(F3:F35)-COUNTIF(F3:F35,"Yes. I love this")-COUNTIF(F3:F35,"No. I hate it")

Upvotes: 0

BruceWayne
BruceWayne

Reputation: 23283

To count the non-empty cells that are not Yes or No,

=COUNTIFS(F3:F35,"<>Yes. I love this",F3:F35,"<>No. I hate it",A1:A4,"<>")

Upvotes: 0

MarioS
MarioS

Reputation: 262

You could Count Column F, and then subtract it by the formula you already have.

Upvotes: 1

Related Questions