Running some (about 80) mechanical test, I need to always show the current passing percentage.
How would I do this in the easiest way when the results is posted either "P" or "F".
Thanks ahead for any help or suggestion, I really appreciate it very much.
SAMPLE.png
Last edited by dave_; 06-12-2019 at 11:34 PM.
Try something like this
Please Login or Register to view this content.
Happy with my advice? Click on the * reputation button below
Thank you for the very quick reply. It is just what I needed.
Why do I get a percentage error here? It should be 50% (5P,5F)
Attachment 628112
[Solved] by doing the following =COUNTIF(E2:E100,"P")/COUNTA(E2:E100)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks