How to calculate the discontinuity cell, the fastest

Users questions: In these two tables using their own methods of shabu-election to elect a person in the two tables in the value of sum. If the table many cases, the application of what is faster. Thank you for reminding
Experts answer: with lots of conditions and the data combined sum can be. More convenient to use the combined point: as in the table, select a Blank cell (A24), from the data menu, open the "combined", function: sum, reference position: $ A $ 1: $ I $ 22 (through the text box next to the button choice), and point, "adding, in tag location on the hook "first line" and "the most left column," finalized. there are more tables are The same way, as long as each table column headings on the same line. Annex: together. Xls
  • This information provided by the users.Thanks!