Excel how to count data excel data analysis sample tutorial and Excel table sample download.

Move the mouse over the letter of the column you want to count and select the entire column. The number after "Count" displayed in the status bar in the lower right corner is.

Note that titles are also involved in the calculation.

This method can also be used for statistics, sums, averages and other data.

Do you want to get the number of all kinds of filtered content? If there is one, it can be realized by the COUNTIF function.

Assuming that the data is in column A, the operation is as follows:

1. Select the data in column A, use advanced filtering, check "Select non-duplicate records" and confirm.

2. Select the filtered result, copy and paste it into other worksheets (create a new worksheet).

3. Cancel the filtering, and paste the content just copied and pasted into column B (assuming it starts from B 1).

4. Enter =COUNTIF(A:A, B 1) in C 1.

5. Copy down the formula of C 1.