Formulas for Counting the Cells that are Non-Blank in Excel Office!!

In this tutorial, we will discuss the Formulas for Counting the Cells that are Non-Blank in Excel Office 365 with its syntax and brief explanations. Let’ see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Formulas to count cells that are non-blank

General Formula:

• To count the number of cells that are Non-Blank in Excel, use the below formula.

=COUNTA(range)

Explanations for Syntax:

• COUNTA – The Excel COUNTA Function will count the number of cells that contain numbers, text, logical values, and errors and returns the output in numbers. It ignores the Empty cells.
• Range – It represents the input values given in the worksheet.
• Parenthesis () – The main purpose of this symbol is to group the elements.

Example:

• In the below image, we will show you to count the cells that are non-blank.
• First, you need to enter the input values.
• Then, apply the given formula in the selected area.
• After that, it will display the result as shown below.

Example

Conclusion:

From this page, you can learn the Formulas for counting the cells that are Non-Blank in Excel Office 365 with its basic syntax and explanations. Hope that this article is useful to you. If you have any suggestions, leave it in the below comment box. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *Read more onExcel Formulas *!!