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
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!