A high school information technology excel table formula problem, let's take a look at what formula c 19 should write, and then fill it in automatically.

Then drag the fill down.

Note: columns don't need absolute references because they don't need to be filled horizontally. Rows use absolute references to avoid changing row numbers when filling down. However, the data to be counted, B 19, needs to be automatically changed to B20, B2 1 and so on. , so the line number cannot be absolutely referenced.