How to calculate the sum of checkboxes in a column?

Question

XPath

How can you display the number of how many flags Alexander has in the end, and how many Sergey has?

PS In the ideal, of course, so that the flag set was = 1. And the missed one = -2, and as a result the sum was considered. But it's already perfect. But if anyone knows, please help. Or at least tell me where to drop.

Answer 1

/root/span[translate(@style, '; ', '') = 'text-decoration:underline']

Answer 2

For Alexander

=SUM(ARRAYFORMULA(ISLOGICAL(B2:B)*((B2:B*1) + NOT(B2:B)*2)))