display filled vs empty cells in a range

[dr mint]

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

[dr mint]

Oh, the data in the cells is dates

[Paul]

Not sure I understand the problem, although I'm going to assume there's some twist - like there are formulas in B4:B13 but some are returning an empty string ("") and are not truly blank.

=COUNTBLANK(B4:B13) will count the number of blanks, even those that are empty strings.

In that manner, to get the number of non-blanks, you could use something like

=ROWS(B4:B13)-COUNTBLANK(B4:B13)
Hope that helps!

[Paul]

You say they are dates... just static dates and not formulas resulting in dates? If so, then there's no reason why COUNT or COUNTA won't tell you the number of non-blank cells, and COUNTBLANK will tell you the number of blanks.

[dr mint]

Yes, they work (counta and countblank) I am trying to create a formula in a cell outside of the range that will combine all the needed funtions to display what percent of the range has been filled with dates (like 5 out of 10 would return a 50% in the formulated cell)

I have made this work with several cells, I just need to combine the funtions into a single and cant seem to get it.

[Paul]

Ahh, then how about:

=COUNTA(B4:B13)/ROWS(B4:B13)

Then format that cell as percentage.

[dr mint]

Your the man,, worked

Thanks alot