The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: = COUNT (A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5. The SQL COUNT () Function The COUNT () function returns the number of rows that matches a specified criterion. COUNT Function The COUNT function is a premade function in Excel, which counts cells with numbers in a range. It is typed = COUNT Note: The COUNT function only counts cells with numbers, not cells with letters. The COUNTA function is better used if the cells have letters. How to use the = COUNT function : Select a cell Type = COUNT Double click the COUNT command Select a range Hit enter Let's see some examples! Apply the = COUNT function to range D2:D21. Counting the cells of Pokemon Total stats ... (transitive & intransitive) If you count something, you find how many there are, usually by looking at them one by one. OK kids, first everyone get on the bus, and then we'll count to see that everyone's here.