Select a blank cell, and then on the Insert tab, click Symbol.
Insert Bullets in Excel At the bottom of the dialog box, type 2022 in the Character code box. Then click Insert, and Close. The COUNTBLANK function in Excel is designed to count empty cells in a specified range.
COUNTBLANK Function in Excel It belongs to the category of Statistical functions and is available in all versions of Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, and Excel 2007. The COUNTA function counts cells containing any type of information, including error values and empty text (""). For example,
COUNTA Function in Excel if the range contains a formula that returns an empty string, the COUNTA function counts that value. The COUNTA function does not count empty cells. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.
Count Function in Excel For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.