Calculated percentage of column filled

[rnanderson]

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.

 

[MickG]

Try:-

[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

 

[Jonmo1]

Could be

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