Hi guys, I'm trying to create a formula to count the percentage of progress based on a drop down menu containing text values such as PASS,BLOCKED ecc.
Now I would usually use something like this:
=(COUNTIF(E4:E148,"PASS")+COUNTIF(E4:E148,"FAIL")+COUNTIF(E4:E148,"BLOCKED")+COUNTIF(E4:E148,"N/A"))/(COUNTBLANK(E4:E148)+COUNTA(E4:E148))
The only problem is that with the current file format I am forced to have empty cells in the row, and that obviusly count as missing progress, therefore I am unable to achieve 100%.
Untitled.jpg
I am attaching a screenshot hoping to help you understand what I am talking about, spent 6 hours trying to figure it out, my brain is melting right now.
Thank you very much for your help.
Please help me.
Bookmarks