How to realize data Counting with Excel

This article will explain in detail how to achieve data counting in Excel. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

In Excel, we use "PivotTable" to realize the total counting and some techniques of "count" class functions.

1.1 Select data and insert PivotTable report

1.2 Select the fields to count

2.count class function

Count (range) calculates the number of numeric cells in the selected region

Counta (range) calculates the number of non-empty cells in the selected range

Countblank (range) calculates the number of blank cells in the selected area

Countif (range,criteria) calculates the number of cells in the selected region that satisfy the conditions (can be matched with wildcards)

This is the end of the article on "how to achieve data counting in Excel". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.