How to solve a problem with a condition and flags in Excel?

Question

excel

1) Column with flags (true/false);
2) A column with a number opposite the flags;
3) a cell with a sum of numbers;
Question:
How to calculate the sum of the numbers in the "total" cell, opposite which the checkboxes are marked?

Link to google spreadsheet with the task
Thank you in advance for your answers!

Answer 1

I found the formula:
SUMIF(range, criterion, [sum_range])
In the first parameter, we pass the column with flags (true / false)
The second parameter: this is the criterion (in our case, "=TRUE")
The third parameter, we pass the column with numbers. And this function already has the logic to summarize this column.
Exactly what you need
. As a result, we get a working functionality using:
=SUMIF(A2:A10, "=TRUE", B2:B10)