Excel

Are you tired of manually counting blank cells in your Excel sheets? Here's how to do it in just a few simple steps!

The formula we used summons the COUNTBLANK function to look through cells C2 and C11 (which are the lap times for the second lap) and returns the number of empty cells. COUNTBLANK is a built-in function designed specifically to do one thing, and that is to count blank cells. Of course, since the data table in this example is a small one, you could also count them yourselves, but why do that when you could use COUNTBLANK? The goal is to get the number of contestants who only did one lap. Thanks to the COUNTBLANK function, counting blank cells in Excel is a breeze. Excel is a powerful tool to analyze and demonstrate data and is often used in statistics.