The table below shows crop production by country for 2018. You want to know the number of countries for which we have banana production data. The COUNT function counts the number of numerical values in a range of cells and will ignore text, so you can write the following function to count the number of countries for which we have banana production data:
=COUNT(B:B)
Try typing the formula into cell F2. What is the result of the formula?