COUNTIF formula and example in Excel and Google Sheets

Formula, examples and how to use it

=COUNTIF(range, criterion)

One of the most popular functions used in Excel and Google Sheets, and COUNT values based on a condition. In this exercise, we will analyze the "Oil and gas" industry