# Calculated percentage of column filled

#### rnanderson

##### New Member
I would like to figure out a formula that will calculate what percentage of a column is filled based on the total number of rows.

For instance if I have Column K and that will have delayed savings by sales pursuit, I want to be able to calculate the percentage of what is being delayed from a total number of pursuits (basically the count of rows in column A). Ideally this would be a dynamic range (offset).

Ex. Say I have 25 rows in column A, but I only have 2 rows in column K filled. How can I calculate that there is a 8% (2/25) delay??

Any help or insight would be great. Thanks in advance.

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Try:-
Code:
``````[COLOR="Navy"]Sub[/COLOR] MG07Jan44
MsgBox Format(Application.CountA(Range("K:K")) / Application.CountA(Range("A:A")), "0%")
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]``````
Regards Mick

Could be

=COUNTA(K:K)/COUNTA(A:A)

Replies
0
Views
428
Replies
2
Views
129
Replies
2
Views
82
Replies
5
Views
399
Replies
0
Views
154

1,203,112
Messages
6,053,577
Members
444,674
Latest member
DWriter9

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back