I have been trying to use counta and countblank to obtain the filled and empty cells in a range and return the completed by %
I have achieved this using mulitple cell feed but need it in all in a single cell if pos.


B4:B13 are the data cells (range),, how can I get the % of completed or filled cells in the range to display in cell C14

I will be greatfull for any help