Saturday, May 18, 2013

[Excel Tips] - How to Calculate the Percentage of Filled Data in Excel

Posted by Sharath Chandra
Hi Friends, 

Recently I got a requirement to calculate the percentage of excel sheet fillings - So here I am explaining how can we do that.

Simple we can do this with COUNTA formula from Excel! 

COUNTA function counts the number of cells that are not empty as well as the number of arguments that contain values.

Applies To
Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Example: 

- Lets assume we have a 10x3 (RxC) data.
- So our formula will be like this 

=(SUM((COUNTA(A2:A11)/10),(COUNTA(B2:B11)/10),(COUNTA(C2:C11)/10))/3)*100

- Why /10 means we have 10 rows 
- Why /3 (at end) means we have 3 columns

Here is the snapshot for your refernece. 



Let me know through comments - if you have any simple formula than this - because it will be difficult if we have more columns! 

Please Share This - Because Sharing is Gaining in Knowledge!