# Sheet Summary Won't Count # of Cells with %

Options
✭✭✭

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?

Tags:

Options

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!

Options

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!

• ✭✭✭
Options

Thanks @Tamara Purchase, that worked! 🙂

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!