# COUNT Excel Data using COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS | Excel Formulas | Excel Functions |

## 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.

### 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)