Microsoft Excel Formula to Count all the Empty Cells.

Posted on October 29, 2007 
Filed Under Excel Tips & Tricks

It can be useful if you are working in a large Excel Spreadsheet to count the empty cells. This is a Microsoft Excel Tutorial to show you how to use this Excel Formula. I hope you’ll enjoy this quick Tip.

 

How to use the “Countblank” Function. 

  • Create some data in Cell A1:A15 and leave a few cells blank.
  • Select Cell B1 and type in the formula =Countblank(A1:A15)
  • Press Enter

Excel Tip Trick

 

 

 

 

 

 

 

 

 

 

 

 

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

One Response to “Microsoft Excel Formula to Count all the Empty Cells.”

  1. M.Zaman on October 19th, 2008 6:22 am

    please sent me formula of ms excel all….

Leave a Reply