COUNTIF to reference another sheet.

I am trying to use the COUNTIF formula to count the number of times a certain text appears in a column. I can easily do this, if I am working on that sheet, but if I want to reference another sheet it wont work.

North Coast FY24 (2023-2024)= the name of the spreadsheet

Clean Water for Reefs= the text I am trying to get a count for

=COUNTIFS({North Coast FY24 (2023-2024) Range 1}, "Clean Water for Reefs")

The same happens when I try to refereence another column of "State". It is the same sheet but the column is called state and I am trying to count how many times "not started", "in progress", etc. appear.

Note: both these columns are set as dropdowns. Not sure if that effects anything.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

What do you mean when you say it won't work? Are you getting a different count or an error message? What is the formula that does work when on the same sheet?

Taylor Cook

I have tried to write it a few different ways. It either gives me an incorrect number/doesn't change when I adjust the spreadsheet or it says Unparseable

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.