5 Useful COUNT Formulas in Excel
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 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.
Close bracket & press Enter.
You will Get Result.
COUNTA formula use for count any data from selected range. All data like Numbers, Value, Text, Special characters any data will be count.
As per formula name count blank cell from selected range.
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.
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 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.
Select 1st range press comma select first criteria press comma select second range press comma select 2nd criteria ……..
You can use multiple criteria.