Counting Columns

This discussion was created from comments split from: Партнёр в сообществе.


  • Roman Dianov

    Good day. I ask for your help. Every number in the calendar is counted by employees per day, night, swing. Help me find a formula so that the columns contain a score of the categories of each employee. thank.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Roman Dianov

    You can use a COUNTIFS formula to count how many times each employee appears with each category/column.

    A COUNTIFS works like this:

    =COUNTIFS([Column 1]:[Column 1], "Criteria 1", [Column 2]:[Column 2], "Criteria 2"...etc

    So for your first person and column, try something this:

    =COUNTIFS([категория]:[категория], "D2", [пн 22]:[пн 22], <> "")

    <> "" means that the cell is Not Blank.

    You will need to update each formula to look into a different column as the second criteria. So the next row would be:

    =COUNTIFS([категория]:[категория], "D2", [вт 23-]:[вт 23-], <> "")

    Or whatever the name of that column is. Does that make sense?

    As an alternative, you may want to create a Report (see here) of this sheet instead. Then you can Sort the Report by the people in the категория column, Grouping it by this column (see here), and doing a COUNT as a Summary for each other columns. Would this work for you instead?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!