Counting matching pairs of checkboxes

A matching pair is two checked checkboxes, one from the 'Selection' column and one from 'Criterion 1', or 'Criterion 2' etc.

So, all matching pairs in my example are:

• Match with 'Criterion 1' – three matches (C2)
  • B3 and C3
  • B4 and C4
  • B8 and C8
• Match with 'Criterion 2' – one match (E2)
  • B4 and E4

Not quite:

Columns C and E are independent. Column D (as per below example) is just an alternative way to calculate the score, but in a way that I want to avoid, because I would have to create a separate column for each of the 'Criterion' columns. I currently have 40 of these 'Criterion' columns. So:

• Total for column C: All rows will be counted as long as column B & C in this row are checked
• Total for column E: All rows will be counted as long as column B & E in this row are checked

Hope that makes sense

Thanks!

No, the score is a sum of the values in a column. The score is a the number of matches between 'Selection' and 'Criterion X':

• column B 'Cr 1': 3
• column C 'Cr 2': 2
• column D 'Cr 3': 1

I'm aware that it's easy enough to just add the values in each column (B2:B8, C2:C8, D2:D8) for the score. But:

• Do I have to use a separate (auxiliary) table ('Scores') to achieve this? My data is growing on a daily basis and I'm looking for a solution that would ideally create that in one formula.
• Is there no way to calculate the score for each column in a formula in 'Table 1' without adding extra columns or tables?

Thanks. Actually my table is a lot more complex than I've shown here, which is why I need to avoid a separate table for the calculation. In addition, my table grows horizontally on a daily basis and over time vertically too. And I have to keep it in the one table.

I'll accept this as a helpful answer though.

Sorry, my bad. You're correct

• Match with 'Criterion 2' – two matches (E2)
  • B4 and E4
  • B5 and E5

And that sum should obviously be "2" then.

Thanks for spotting.

Oh, I see. I'll have to set it as a footer (or header) row. When I tried inserting this into its own body row I'd get a reference error:

Thanks, I'll accept that as a solving answer.

Yes, I want to see which criterion is matched by most products.