Exclude Formula/Calculation based on status

[Cyril Beki]

Hello,

I have a progress bar to show the status of a project but I want some of the data will be excluded from the progression I used a drop-down to show "Done, Pending, and Not Available". Below is the image for better understanding and reference.

Progress Bar:

Status:

What I wish is, I need the formula to calculate only if it's stated Done, meaning if it shows "Not Available", then it will be excluded from the formula, so based on the image above, it should show 100% of progression instead of 71% since the rest I marked as "Not Available". Hope someone can help

here is the formula i currenlty used: =COUNTIF(F3:F28,"Done")/COUNTA(E3:E28)

 

[awoohaw]

try:

=COUNTIF(F3:F28,"Done")/  ( COUNTA(E3:E28)-COUNTIF(F3:F28,"Not Available"))

Why are you counting different columns though? What is the difference between E:E and F:F?

Maybe you should be using:

=COUNTIF(F3:F28,"Done")/  ( COUNTA(F3:F28)-COUNTIF(F3:F28,"Not Available"))