COUNTIF #UNPARSEABLE ERROR
Hello
Can someone help me understand what's wrong with this COUNTIF function?
=COUNTIF({Project Priorities}Platform:Platform,"Apple")
The goal is to count the number of times the word "Apple" is displayed in the "Platform" column within the "Project Prioritities" referenced sheet. Thank you in advance.
Best Answer
-
I think your error is in your offsheet reference.
When you build a formula that references another sheet, the reference is actually to a range on the other sheet.
So for my source sheet, here is the column I want to count:
On my second sheet where I want the countif function
Click the "Reference Another Sheet' and that will open another window. Find the sheet you want to reference and click it. You should now see all the columns in that sheet. Click the column that contains your data you want. Then, look at the top of the window and find this box
Type in what you want to call the reference. In this case I called is Platform_ref. I usually add '_ref' to mine to make it easier to know that it is an offsheet reference. Once you have the column selected and the reference named, click the blue button (bottom right) that says 'Insert Reference'
Now your formula is referencing the offsheet column. The rest of the formula is:
=COUNTIF({Platform_ref}, "Apple")
{Platform_ref} is already pointing at the column you want, so no need to include the column name in the formula.
Answers
-
I think your error is in your offsheet reference.
When you build a formula that references another sheet, the reference is actually to a range on the other sheet.
So for my source sheet, here is the column I want to count:
On my second sheet where I want the countif function
Click the "Reference Another Sheet' and that will open another window. Find the sheet you want to reference and click it. You should now see all the columns in that sheet. Click the column that contains your data you want. Then, look at the top of the window and find this box
Type in what you want to call the reference. In this case I called is Platform_ref. I usually add '_ref' to mine to make it easier to know that it is an offsheet reference. Once you have the column selected and the reference named, click the blue button (bottom right) that says 'Insert Reference'
Now your formula is referencing the offsheet column. The rest of the formula is:
=COUNTIF({Platform_ref}, "Apple")
{Platform_ref} is already pointing at the column you want, so no need to include the column name in the formula.
-
Thank you Jon. I understand now; this worked.
-
Happy to help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!