Hello Gary,

All seems to be working fine.

Thanks for your help!

Shreekant
Have a good weekend!
Shreekant Patel wrote:

Hi Gary,

That worked superbly! Thank you for that funtion. Have one question,
if i wanted to apply this function across my whole worksheet, i simply
just have to modify the column ranges in the formulae right?

srmp
Gary wrote:

=(counta(a1:a10)/(countblank(a1:a10)+counta(a1:a10)))

now format the cell to percentage.

The range that i have given is just an example...u can change it
accordingly.

Let me know if it works.

GARY
wrote in message
ups.com...
Hello Everyone,

Hopefully the solution to this is quite straightforward.

I have an excel worksheet that has about 11000 cells. Some cells have
data in them and some do not.

I need if possible, to calculate the total % of how many cells have
data in them. Columns which are currently blank have been removed.

Could anyone please help me out on this.

Thank you

srmp.