Need formula help

[mrskidder]

I am putting together an Audit PBC list and need to be able to have percentage completion for each section. I have drop downs that give the options of Complete, In Progress, Not Started, and N/A. I need to have the completion include everything except the N/A options.

For example, if I have 4 items and three are complete and one is N/A, then instead of 75% complete, it needs to be 100% complete (when complete is chosen).

I have the formula to count all cells but am unsure how to add in the piece that won't count the N/A.

=countif(F37:F40,"Complete")/counta(F37:F40)

 

[jkpieterse]

Replace the counta(F37:F40) with countif(F37:F40,"<>N/A")

 

[mrskidder]

Replace the counta(F37:F40) with countif(F37:F40,"<>N/A")

Thank you!!!!