Different COUNT functions in Excel: How to use these functions

Different COUNT functions in Excel

Excel COUNT function is a very important function in excel and it is being used very frequently. There are five COUNT functions in excel(count, counta, countblank, countif,countifs) that are being used in excel. I will explain every function one by one how to use the count function in excel and have also shared a video with a full explanation.

Count: This function counts the number of numeric entries in a list. It will ignore blanks, text, and errors.Syntax: =COUNT(Range1,Range2,Range3……………….,RangeN)

Different COUNT function in Excel
Different COUNT functions in Excel

Counta: This function counts the number of numeric and text entries in a list. It will ignore blanks.Syntax: =COUNTA(Range1,Range2,Range3……………….,RangeN)

counta function in excel
counta function in excel

Countblank: This function counts the number of blank cells in a range.Syntax: =COUNTBLANK(Range1,Range2,Range3……………….,RangeN)

countblank function in excel
countblank function in excel

Countif: Countif function in excel counts the number of items that match the criteria set by the user.

Syntax: =COUNTIF(RangeOfcriteriaToBeCounted , CriteriaToBeMatched)

countif
countif function in excel

Countifs: The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met.

Syntax:=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

countifs function in excel
countifs function in excel

I am sharing all this in the below video. Kindly watch this and share feedback and don’t forget to subscribe and share our channel.

You can read more about excel count function from the below article.

https://exceljet.net/excel-functions/excel-count-function

Leave a Comment

Scroll to Top