The COUNT function is a simple function that counts numbers.
Let's take a look.
The COUNT function counts numeric values. For example, if I enter the formula =COUNT(B7:B11), Excel will return 4 because that range contains 4 numbers total.
Count will ignore blanks and text values.
The formula =COUNT(D7:E9) will return 3 because COUNT treats the date, time, and percentage as numbers.
A good way to check the actual value in a cell is to temporarily apply the General format. You can then easily see which values are numbers.
Negative numbers are counted too.
The COUNT function accepts one or more values, up to 255 total, separated by commas, so I can easily enter all previous values individually and get a total count.
Like other functions that accept multiple values, you can can hold down the control key (command on a Mac) and Excel will add the commas for you, each time you click a new location on the worksheet.
Note that if you want to count text values, you'll want to use the COUNTA function.
The Excel COUNT function returns the count of values that are numbers, generally cells that contain numbers. Values can be supplied as constants, cell references, or ranges.
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
Quick, clean, and to the point.