Excel, Data, Data Analysis, Analytics.
want to look for. For Spain, I type =COUNTIF(B2:B9, “Spain”) For Belgium, I type =COUNTIF(B2:B9, “Belgium”) For Australia, I type =COUNTIF(B2:B9, “Australia”) IF() IF() lets you use conditional logic. The IF function checks if a condition is met, and returns one value if true and another if false.