In this article, you will learn how to count the blank and how to count not blank cells in Microsoft Excel. In Excel we have functions to count the blank cells and non-blank cells.
COUNTBLANK: - When we want to count blank cells only within a range then we use COUNTBLANK functions.
Syntax:-
COUNTA: - This function we use to count the cells within a range which is not empty.
Syntax:-
Count Blank Cells
Let’s take an example:-
First we want to calculate the blank cells in Column A, follow below given steps:-
Now we count the blank cells in 2 columns together, follow below given steps:-
Count Non-Blank Cells
Let’s take an example:-
First we want to calculate the blank cells in Column A, follow below given steps:-
Now we count the blank cells in 2 columns together, follow below given steps:-
Key take away:-
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
sir pls add more example with large data