Count Function in MS Excel

You are here : Home / MS Excel tutorials for beginner to experts

By Shivani Garg

The Count function is one of the most used functions in MS Excel. This functions let you count the cells based on one or multiple criteria.

How to use Count Function in MS Excel

The "Count" function is very useful for large Worksheets that have variety of data types.

In the Count Function we will learn how to use

• COUNT

• COUNTIF
• COUNTIFS

How to use COUNT function

Let's learn with Example

COUNT function is used to count the number of cells that contain numbers .

D6 equals =COUNT(C2:C6)

How to use COUNTIF function

Let's learn with Example

COUNTIF function is used to count cells based on one criteria .

For example, for counting the values greater than 40 

D6 equals =COUNTIF(C2:C6,”>40”)

Read More on COUNTIF Function In MS Excel

How to use COUNTIFS function

Let's learn with Example

COUNTIFS function is used to count cells based on multiple criteria

For example, for counting the values Sunflower and greater than 40 

D11 equals =COUNTIFS(B2:B11,”Sunflower”,C2:C11,”>40”)

Read More on Functions :

Sum Function in MS Excel

COUNTIF Function In MS Excel

SUMIF Function In MS Excel

Also Read, 

MS Excel tutorials for you :)

Related >>

1. Range in MS Excel
2. Fibonacci Sequence in MS Excel
3. Transpose in MS Excel
4. Hide Columns or Rows in MS Excel
5. Skip Blanks in MS Excel
6. Comments in MS Excel
7. Formulas and Functions in MS Excel
8. Percent Change in MS Excel
9. Paste Options in Ms Excel
10. Status Bar in MS Excel
11. Ribbon in MS Excel
12. Templates in MS Excel
13. Find & Select in MS Excel
14. Data validation in MS Excel
15. Print in MS Excel
16. Share MS Excel Data in Word Documents
17. Share MS Excel Workbook with Multiple Users
18. Magical keyboard shortcuts in MS Excel with examples
19. Very Important  Keyboard Shortcuts in MS Excel
20. Freeze Panes in MS Excel
21. Split Workbook in MS Excel
22. Spell Check in MS Excel
23. Protect Worksheet in MS Excel
24. Protect Workbook in MS Excel
25. Lock Cells in MS Excel
26. Read Only Workbook in MS Excel
27. Mark Workbook as Final in MS Excel
28. Drop Down List in MS Excel
29. Setting Budget Limit in MS Excel
30. Prevent Duplication in MS Excel
31. Count Function in MS Excel     
32. Sum Function in MS Excel
33. COUNTIF Function In MS Excel
34. Count Characters in MS Excel
35. Running Total (Cumulative Sum) in MS Excel
36. SUMIF Function In MS Excel
37. Logical Functions in MS Excel
38. IF Function in MS Excel
39. Cell References in MS Excel
40. Create Hourly Pay Sheet using Absolute Reference in MS Excel
41. Copy Exact Formula in MS Excel

Labels: MS Excel Shivani Garg