Counting Columns

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

Answers

  • Screenshot.png

    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.

  • 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?

    Cheers,

    Genevieve

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!