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.