Excel, Data, Data Analysis, Analytics.
“United States” is the criteria I want to look for. This gives me the result 3, which is correct. 3 participants came from the United States. I use the formula =COUNTIF(B2:B9, “United States”) to count the number of participants from the US. Then, I re-type the formula using the other criteria I