How can I use COUNTIF to count rows?

I am linking a report with another spreadsheet and each row in the spreadsheet is labeled either Facebook or Google. In my report, I need the total number of rows for Facebook or Google in order to figure out other calculations for my social media report. I have tried using:

=COUNTIF({Social Media Data 2021 Range 8}, CONTAINS("facebook"))

This comes back as #INVAID OPERATION.

The way I normally see the COUNTIF function used is to collect data from column A if criteria is met in column B , but I just need a total number of rows. Any suggestions on how to accomplish this?

Find more posts tagged with

Accepted answers

All comments

Nic Larsen

Try this

=COUNTIF({Social Media Data 2021 Range 8}, CONTAINS("facebook", @cell))

Updated - had my " in the wrong spots.

Cindi Meche

Hi Nic. I tried that and even checked the criteria, but it's not working. Still says #INVALID OPPERATION.

=COUNTIF({Social Media Data 2021 Range 8}, CONTAINS("Facebook, @cell"))

Should the @cell count the cells (therefore rows)?

Nic Larsen

Be sure to use the revised formula one I put in there. I had my quotes around @ cell rather than around facebook when I first submitted.

=COUNTIF({Social Media Data 2021 Range 8}, CONTAINS("facebook", @cell))

Is your range a single column? If so, this worked fine for me when I tried it.

You can also run it this way - depending on if there is other data in the cell other than facebook/google:

=COUNTIF({Social Media Data 2021 Range 8}, "facebook"

Cindi Meche

That's it! It worked! Thank you so much for your help.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.