Excel, Data, Data Analysis, Analytics.
separate table and list out the countries: United States, Spain, Belgium, and Australia. I use COUNTIF() to count the number of participants from the United States: =COUNTIF(B2:B9, “United States”) “COUNTIF” counts cells based on certain criteria. “B2:B9" is the range of cells I want to examine.