## 5 Useful COUNT Formulas in Excel

### Introduction-

Count your Data with different conditions. Separate formula use for particular condition. Numerical value, Text value, Blank Data, Filled Data & Given Criteria wise data any data count using this 5 formulas.

**COUNT Formula**

Count formula use for count only numerical value from selected data.

In the following image in the column D available some DATA with text, Number’s & Special Characters. Count formula find only numerical value & count.

Form apply count formula press =COUNT(

Then Drag the data range.

**=COUNT(D3:D17)**

Close bracket & press Enter.

You will Get Result.

### COUNTA Formula

**COUNTA**formula use for count any data from selected range. All data like Numbers, Value, Text, Special characters any data will be count.

**=COUNTA(D3:D17)**

### COUNTBLANK Formula

As per formula name count blank cell from selected range.

**=COUNTBLANK(D3:D17)**

### COUNTIF Formula

**COUNTIF Formula**Use for count data only in given condition.

In the following screenshot in column C Name available.

We can count only particular name is repeat how many time.

We are counting Jhon Name.

For count if formula need range & criteria.

Range is our data column. & criteria is what is finding in range.

Here name column is our range & particular name is Criteria.

**Type =COUNTIF(**

then select name data range press comma & type

**“Jhon”**& close the bracket.We can use cell if criteria is available in the particular cell.

5 time Jhon’s name is repeated. We get the result using formula.

### Click here to Learn another example of COUNTIF & COUNTIFS

### COUNTIFS Formula

COUNTIFS formula use for multiple criteria counting.

In the Screenshot Jhon text name is repeated 5 times. But we will finding in the particular date how many time repeat Jhon Name.

On 15-10-19 two times available Jhon.

We are using 2 criteria & 2 range.

First Range is date column & criteria is Particular date.

Second Range is Name column & criteria is Particular Name.

Type

**=COUNTIFS(**

Select 1st range press comma select first criteria press comma select second range press comma select 2nd criteria ……..

You can use multiple criteria.

**=COUNTIFS(B3:B17,B25,C3:C17,B26)**