Unit 23: Formulas


Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. 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.


The Excel COUNTA function returns the count of cells that contain numbers, text, logical values, error values, and empty text (“”). COUNTA does not count empty cells. Count the number of non-blank cells. A number representing non-blank cells.


If there is more than one range and criteria, you can use COUNTIFS function. It works same as COUNTIF, but is used with multiple criteria. The syntax of the COUNTIFS is: =COUNTIF (range 1, criteria1, range 2, criteria 2..)


Use the COUNTBLANK function to count blank cells in a range, where the word blank means empty. For example, COUNTBLANK (A1:A10) will count the number of blank cells in the range A1:A10. Cells that contain text, numbers, errors, etc. are not counted.

UNIT 23 – Formulas

There aren't any posts currently published in this category.