Does the COUNTIF Function work if the criterion have decimal places?
I am working on an extended process and I want to sub-categorize a set of steps. Ideally I want to use the 1.1, 1.2, 1.1.1 as step headers but when I try and do functions to count cells it is not working.
The COUNTIF functions work for the whole numbered entries but will not pull with the decimal entries. Here are the two formulas I am using:
=COUNTIF([Current Pipeline Stage]:[Current Pipeline Stage], "3 engaged")
=COUNTIF([Current Pipeline Stage]:[Current Pipeline Stage], "4.1 Drafting")
Any suggestions on how I can get those formulas happy again?
Help Article Resources
Check out the Formula Handbook template!