Need help getting count if "all continents" are selected in dropdown and counts

[macattack1]

Hi everyone. I hope you are doing well. I am having some trouble returning all values in a data set in a dropdown for a graph. I am attempting to build an excel formula using COUNTIF and embed syntax in there that if I select "All continents" for example in the dropdown it will return all values in the pivot table. This is the syntax I have thus far:

=COUNTIF([@[ Continent]],'Dashboard one'!$N$204)

This seems to work for the individual selections. However trying to embed an if statement to refer to "all continents" is more difficult.
Does anybody know how I can embed the IF( N204 = "All continents", return all values for count)? Please let me know if that is possible in excel. I would really appreciate any help and thanks again for anybody's assistance in that matter. Have a terrific Friday.

 

[Eric W]

Try:

=COUNTIF([@[ Continent]],IF('Dashboard one'!$N$204="All continents","*",'Dashboard one'!$N$204))

 

[macattack1]

That worked. Thank you so much Eric!

 

[Eric W]

Happy to help! Thanks for the feedback.