Dear Analyst

Dear Analyst


Count the number of blank values in a range in Excel

April 29, 2019

If you want to count the number of cells with blank values in them, you may think it’s as simple as using the COUNTBLANK() formula. Usually you do this if you want to know how much data is missing in your data set. Say you have a list of 10 students,