Why isn't my % Complete count if working
I can't get my CountIf formula to work completely on the % Complete Column of my project sheet: =COUNTIF([% Complete]:[% Complete], =100)
It does return return 3 when I have the criterion set to =0. It returns 0 when the criterion is set to =3 or =100. I have tried "3%" and "100%" as well but it still comes back 0. I don't get it.
Help Article Resources
Check out the Formula Handbook template!