Range Percentage Formula

[pure vito]

Good Morning Experts,

Could i ask for some help please,

I have a range of cells from H2-H500 and L2-500,

I need a formula to tell me the Percentage of cells with a value, for example if i had 100 rows one mark on each row would = 1% no matter if their were more marks on a single row across the H-L range.

I really hope this makes sense i have attached a picture to help.

Thank You,

 

[pure vito]

 

[Fluff]

Duplicate to: Percentage Formula

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.