Count Formula

1. COUNT 

The COUNT function counts all cells in a given range that contain only numeric values.

Example:

=COUNT(value1, [value2], …)

=COUNT(E2:E14)

2. COUNTA

Like the COUNT function, COUNTA counts all cells in a given rage. However, it counts all cells regardless of type. That is, unlike COUNT that only counts numerics, it also counts dates, times, strings, logical values, errors, empty string, or text.

Example:

=COUNTA(value1, [value2], …)

=COUNTA(E2:E14)

3. COUNTIF

COUNTIF is an Excel function to count cells in a range that meet a single condition. COUNTIF can be used to count cells that contain dates, numbers, ...

Example:

=COUNTIF(range,criteria)

=COUNTIF($R$4:$R$54,X5)

4. COUNTIFS

COUNTIF is an Excel function to count cells in a range that meet a single condition. COUNTIF can be used to count cells that contain dates, numbers, ...

Example:

=COUNTIFS(criteria_range1,criteria1,critera_range2,criteria2…...)

=COUNTIFS($AE$4:$AE$54,">250",$AB$4:$AB$54,$AG14,$AD$4:$AD$54,AH$12)

5. COUNT COUNTRY CODE (DOSEN'T INCLUDE '0')

Example:

=SUM(IF(VALUE(RIGHT(AO5:AO20,1))=0,"",1))

6. COUNT THE ONLY ERROR VALUES

Example:

=SUMPRODUCT(--ISERROR(AU4:AU25))

7. COUNT THE ONLY >=50

Count the only selected value or fixed number in the data

Example:

=SUM(IF(VALUE(IFERROR(VALUE(IFERROR(VALUE(RIGHT(AZ5:AZ25,2)),LEFT(AZ5:AZ25,2))),LEFT(AZ5:AZ25,1)))>=50,1,0))