Sheet Summary Won't Count # of Cells with %
![Jodi C](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hello,
I have a sheet that has a column for % complete and I cannot get the formula in my sheet summary to count the # of cells that are 25%, 50%, 75% or 100% complete.
The formula I'm using is =COUNTIF(Percent:Percent, "25"). This seems to work to count any that are 0% but none of the other numbers.
What am I doing wrong?
Best Answer
-
Hi Jodi C,
Percentages are actually expressed as decimals when you are looking to count the instances of a number value occurrence. For example, 25% is equal to 0.25. You can see this if you change the number format of your Percent column. Try rewriting your formula like this: =COUNTIF(Percent:Percent, 0.25).
Hope this helps!
Answers
-
Hi Jodi C,
Percentages are actually expressed as decimals when you are looking to count the instances of a number value occurrence. For example, 25% is equal to 0.25. You can see this if you change the number format of your Percent column. Try rewriting your formula like this: =COUNTIF(Percent:Percent, 0.25).
Hope this helps!
-
Thanks @Tamara Purchase, that worked! 🙂
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!