Count: Function The COUNT function is

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 ... The Excel COUNT function returns a count of values that are numbers. Numbers include negative numbers, percentages, dates, times, fractions, and formulas that return numbers. Empty cells and text values are ignored. You can ignore duplicates by using the DISTINCT keyword in the COUNT() function. If DISTINCT is specified, rows with the same value for the specified column will be counted as one.