Percentage complete of blank/not blank dates in a column

I am looking for a formula that can show me a percentage of blank cells/non blank cells in a column.

Ex: My Column is titled: CPD Complete Date.

There are 10 cells in the column

Only 5 of the cells have dates

I would like a formula that can show this is column is 50% completed based on how many blank cells there are to how many dates are filled in.

Is this possible? Thanks!

Find more posts tagged with

Comments

L_123

=count([CPD Complete Date]:[CPD Complete Date])/(countifs([CPD Complete Date]:[CPD Complete Date],not(isblank(@cell))+count([CPD Complete Date]:[CPD Complete Date]

Something like that should do you.

Sign in to join the conversation!

Quick Links

Trending discussions

How to prevent or recover deletion of rows
Is it possible to prevent the deletion of rows in a sheet? Specifically, in cases where a user legitimately requires editor permission to the underlying sheet and where the row cannot be locked (as continued editting of the row is required.) If not, what are some strategies for recovering a row that has been inadvertently…
Dashboard Adding Widgets Spontaneously
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…