How to use excel count function

How to use excel count function?

1. The COUNT function is a counting function. The COUNT function can reference 1 to 30 parameters of various types of data. It can be cells, numbers, dates, etc., but it must be in the form of numbers

2. Enter 10 numbers, and then use the formula =COUNT(A1:A10) to calculate the number. There are numbers in cells. After pressing Enter, you will get the result

3. Enter 8 dates, then enter the formula =COUNT(C1:C8) to calculate the number and press Enter. After that, you get the result

4. Enter 8 letters, and then enter the formula =count(C14:C21) to calculate the number. After pressing Enter, you get the result 0, no Counting the numbers shows that the count function is invalid for letters

5. Add 1000 to the formula =COUNT(A13:A22,1000) and press Enter to get the result 1 , indicating that count is invalid for Chinese characters, but valid for numbers in formulas, and is recorded as 1

6. Delete one number and enter the formula =COUNT(A1:A10) Calculate the number, press Enter, and get the result, indicating that count automatically ignores empty cells

The above is the detailed content of How to use excel count function. For more information, please follow other related articles on the PHP Chinese website!