help with countIFS

sonam.bang

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))

Mike Wilday

100% in smartsheet percentages is depicted as a 1.0. You have 0.1 which is in effect counting anything that equals 10%. Try changing the 0.1 to 1.0. That should do the trick! 

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

sonam.bang

ahh..that was it..thank you so much.

Mike Wilday

You're welcome. I'm glad I could help you figure it out!