COUNT, COUNTA, COUNTIF Function in Excel

The COUNT function is a function in Excel, which counts cells with numbers in a range.

=count(range) 

count formula

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(
• Select a range
• Hit Enter

COUNT function, step by step:

• Select D13
• Type =COUNT
• Double click COUNT in the menu
• Select range E2:E11
• Hit enter

COUNT ID

Basic Count Formulas:

COUNT               =COUNT(A2:A10)          Counts numbers in range 

COUNTA              =COUNTA(B2:B10)         Counts non-empty cells

COUNTBLANK    =COUNTBLANK(C2:C10)     Counts empty cells

COUNTIF             =COUNTIF(D2:D10,">50")  Counts cells meeting one condition

COUNTIFS           =COUNTIFS(E2:E10,">50",F2:F10,"<100")  Counts cells meeting
                               multiple conditions  E2:E10, F2:F10  

counta countblank countif example