Counting Columns

Answers
-
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.
-
You can use a COUNTIFS formula to count how many times each employee appears with each category/column.
=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
Help Article Resources
Categories
Check out the Formula Handbook template!