COUNTIF to reference another sheet.

Taylor Cook

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.

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