CODEWITHSUNDEEP
excel
RichardS
RichardS

Reputation: 85

How can I calculate % completed with a column that is either blank, has a date or the word "pending"?

I have data like below. Each row has either a blank (don't count), a date (completed) or the word Pending (not started). Is there a formula I can use on the bottom rows that will check all the rows above and tell me the % that have been completed? So for the case of Angelica who has completed 11 of 12 in total I would like to see: 92%

enter image description here

Note the first column to count here is E4 and the last E17. I would like to get the percentage in E18.

Upvotes: 0

Views: 219

Answers (2)

sophocles
sophocles

Reputation: 13821

You can do this:

=(1-(COUNTIF(A3:A17,"Pending")/COUNTA(A3:A17)))*100

Which gets:

enter image description here

Upvotes: 0

basic
basic

Reputation: 11968

Use COUNTA/COUNTIF:

=1-COUNTIF(A3:A17,"Pending")/COUNTA(A3:A17)

enter image description here

Upvotes: 1

Related Questions