Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Web services | Google Drive | Calculate number of empty cells in Google spreadsheet
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

Calculate number of empty cells in Google spreadsheet

Google Spreadsheets supports cell formulas typically found in most desktop spreadsheet packages. In this lesson we will calculate the numbers of empty cells in a Spreadsheet.

 
  Author: bole | Version: | 1st November 2013 |  
 
 
1.
 

Open your Google account and create new Spreadsheet.

 
 
2.
 

Enter any data.

You can also copy mine.

 
 
3.
 

Now select the cell where you want to calculate numbers of empty cells.

 
 
4.
 

Click Function icon and select More functions…

 
 
5.
 

In new window click Narrow by …

 
 
6.
 

…and select Math.

 
 
7.
 

Now find the function you want. In my case this is COUNTBLANK().

 
 
8.
 

Type an equal sign in selected cell.

Auto-suggest will show a box displaying the name and syntax of the formula you're building. Select the function you want.

 
 
9.
 

Select the range of the cells you want to calculate and press ENTER.

 
 
10.
 

In my case I have 2 empty cells in column B.

 
 
11.
 

Now we will use the same function in the other column.

Select the cell where you just calculated the numbers of empty cells and press Ctrl + C to copy the function.

 
 
12.
 

Now select the cell in second column, where you want to count numbers of empty cells and press Ctrl + V to paste the function.

 
 
 
   
  Please login to post a comment
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO