1) Use the summation function to count the total number of papers published by all teachers and put them in cell M9-

The number of published papers is in column H of M9: enter =SUM(H:H) and press enter.

2) The third digit from the left of the number is the department code. In the "Department" column, the conditional function is used to determine the teacher's department.

Enter E2.

= Choose (mid (a3,3, 1), "Management Department", "Accounting Department", "Information Department", "") enter the car and fill it in.

(But what department does "4" stand for? )

3) Complete the statistics on the number of papers of all ages in L5:M8 area, and calculate the proportion of papers of all ages-

Look at your data from line 3 to line 5 1:

l5 input = sum product((D3:d 5 1 >； = 22)*(D3:d 5 1 & lt； =30)*H3:H5 1) Enter;

L6 input = sum product ((D3: D51>; = 3 1)*(D3:d 5 1 & lt； =40)*H3:H5 1) Enter;

l7 input = sum product((D3:d 5 1 >； = 4 1)*(D3:d 5 1 & lt； =50)*H3:H5 1) Enter;

l8 input = sum product((D3:d 5 1 >； = 5 1)*(D3:d 5 1 & lt； =60)*H3:H5 1) Enter;

M5 input =L5/M$9 input and fill it down to M8, and set the cell format to percentage (%).