Combine Countif and Counta and Divide the Total by a number

[Johnny Thunder]

Hello,

I am stuck on a formula...

=COUNTA(J5:J86)-COUNTIF(J5:J86,"NA") Returns 82. and 82=100% and I want to show that on a formula so I put in (See Below)

=COUNTA(J5:J86)-COUNTIF(J5:J86,"NA")/82 and it results in 82 again? when it should show 1?

Does anyone know why or what I can add to this formula to get the desired result? Thank you in advance!

 

[xenou]

=(counta(j5:j86)-countif(j5:j86,"na"))/82

 

[Johnny Thunder]

Thank you very much. Sometimes it the most noticeable things are the one's you forget to look at.

 

[xenou]

Sometimes it the most noticeable things are the one's you forget to look at.

Agreed!