# How to use Excel COUNT function

## SUMMARY INFO

All the basic information regarding Excel COUNT function is listed in the table below. (This data is regularly updated from Microsoft and several resources)

 Function: COUNT Function Category: Statistical Description: Counts how many numbers are in the list of arguments Return Value: A number representing a count of numbers. Syntax: =COUNT (value1, [value2], …) Applies to: Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 Other languages: English: COUNT French: NB German: ANZAHL Spanish: CONTAR Dutch: AANTAL Italian: CONTA.NUMERI Russian: СЧЁТ Danish: TÆL Swedish: ANTAL Portuguese (Brazil): CONT.NÚM Polish: ILE.LICZB Finnish: LASKE Norwegian: ANTALL Portuguese (Portugal): CONTAR Czech: POČET Hungarian: DARAB Turkish: BAĞ_DEĞ_SAY All Other Languages: COUNT Related Functions: COUNTA, COUNTIF, COUNTIFS

## FUNCTION DETAILS

Syntax details with an example regarding the correct usage of function can be seen below.

### =COUNT (value1, [value2], …)

value1 An item, cell reference, or range.
value2 [optional] An item, cell reference, or range.

## VIDEO EXAMPLES

Check the video below to see How to use Excel COUNT function with some examples:

Here we provide a list of useful links which we think can be useful while trying to learn the function usage with some examples and tips.

Microsoft Office support page – Excel COUNT function:
https://support.office.com/en-us/article/COUNT-function-a59cd7fc-b623-4d93-87a4-d23bf411294c

## EXCEL FORMULAS TRAINER

As said: Practice Makes Perfect!

Test your Excel skills in Excel itself with our unique product: Excel Formulas Trainer.

30 sections and around 100 questions with full hands-on experience. Progress tracking, dashboard, error checking and many more. Check it now: