Creating a percentage average from yes /no cells

Hi


I'm trying to use COUNTIF to create a percentage average driven from columns where yes/no/NA are entered can someone help?


Tags:

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    To get a percentage, you would get the number of cells marked as (for example) "Yes" and divide that by the total number of cells.


    =COUNTIFS([Column Name]:[Column Name], @cell = "Yes") / COUNT([Column Name]:[Column Name])

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    To get a percentage, you would get the number of cells marked as (for example) "Yes" and divide that by the total number of cells.


    =COUNTIFS([Column Name]:[Column Name], @cell = "Yes") / COUNT([Column Name]:[Column Name])

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!