How to make a loop or something similar in excel?

Question

excel

Hello. I ask for help, because I am not very familiar with excel, and there is no time to understand VBA. Sorry, time is running out.

You need to do something like

for (cell = A1:A999) {
if (cell == true) {
case (cell(+3 diagonally)):
1 val: 1 cell += 1;
2 digits: 2cell += 1;
default: nothing
}
}

In short, the bottom line is that you need to count all the checkmarks vertically (1 column of checkmarks) and count who has the most checkmarks in the top table. That is, sum up all the checkboxes of one person and write it all down in another table on the same sheet.

Answer 1

This function will help you: https://www.google.com/search?q=sumif
https://exceltable.com/funkcii-excel/funkciya-summ...