Current location - Training Enrollment Network - Mathematics courses - Excel problem, how to count the data in one report to another table?
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.