Excel problem, how to count the data in one report to another table?

For example, the report is the default SHEET 1 and the statistical table is SHEET2. Column A of the statistical table is the school number, column B is the school, column C is the language, column D is the mathematics, and column E is the general evaluation. Data starts in seconds, and is entered in C2 = SUMIF(Sheet 1! $A$2:$A$ 15，Sheet2！ B2， 1！ $D$2:$D$ 15)，D2=SUMIF(Sheet 1！ $A$2:$A$ 15，Sheet2！ B2， 1！ $E$2:$E$ 15)，E2=SUMIF(Sheet 1！ $A$2:$A$ 15，Sheet2！ $B2，Sheet 1！ $ F $ 2:$ F $ 15)/COUNTIF(sheet 1！ $A$2:$A$ 15, $B2) and fill it in.

How to answer the question of quantum mechanics

High school math problems of straight lines and circles are online! ! ! ! Hurry up! ! ! !

Two compulsory topics in mathematics elective course

Peking University Advanced Mathematics Textbook

Brief Introduction of Shiguzhuang Primary School in songzhuang town, Tongzhou District, Beijing

Interesting math problem: weighing stones

How to correctly understand and grasp the classroom teaching activities of primary school mathematics

Which is stronger in finance, Huazhong University of Science and Technology or Wuhan University?

How to prepare for the mathematical modeling competition?

Do you need a ruler to answer this math problem? Four major educational deadlocks behind it.