Counting Columns

System

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.

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