COUNTIF #UNPARSEABLE ERROR

Badou Franck

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.

Jon Baier

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.

Jon Baier

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.

Badou Franck

Thank you Jon. I understand now; this worked.

Jon Baier

Happy to help!