How To Use The Count Function
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 four numbers total. The COUNT function ignores blank cells 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....