Merge three cells B 1:D 1 and enter "Team A";

Enter "goal", "fumble" and "score" in cells B2, C2 and D2 respectively;

Select B 1: D2 cell area, and right click-Copy;

Select the E 1: S2 cell area, and right click-paste;

Change the team name in the first line;

In order to avoid the table being too wide, select columns A ~S, adjust the width to less than one column, and set the alignment in the cell format to "word wrap";

Enter the team names in the A3: A8 cell area in turn;

Enter the formula in the D3 cell: = IF(B3 & gt；; C3，3，IF(B3 & lt； C3，0，IF(B3=C3， 1，""))

Fill this formula to D8;

Select B3: D8 cell area, and right click-Copy;

Select E3: S8 cell area, and right click-Paste;

Merge T 1: T2 cells and enter "Integral";

Enter the formula in T3 cell: =SUM(D3, G3, JBOY3, M3, P3, S3).

Fill this formula to T8, and then end.

When using, find a team from column A, find its opponent on the right, and fill in the number of goals scored and the number of goals conceded on the spot in the appropriate cells at the intersection.

Finally, I will send you a list of goal difference calculations:

(1) Merge the U 1: U2 cell area and enter "Will win";

(2) Enter the formula in cell U3: = B3-C3+E3-F3+H3-i3+K3-L3+n3-O3+Q3-R3.

(3) Fill this formula into U8.