help with countIFS

sonam.bang ✭✭
edited 12/09/19 in Formulas and Functions

I am using the following formula to count the total number of 100%'s in my range. it can count not blanks but doesnt count the total number of 100%'s. Can someone help me. what possibly is wrong in this formula?


=COUNTIFS({Nexus Dependencies Range 5}, AND(NOT(ISBLANK(@cell)), @cell = 0.1), {Nexus Dependencies Range 1}, "FS", {Nexus Dependencies Range 3}, DATE(2019, 10, 31))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!