Organize and Sum Data

The last file you posted is not in the same format as the original requirement. Attached is my last spreadsheet to you. Fill in the information on the Table 1 sheet with a limited amount of data, about 3-5 Line Numbers that we can walk through manually. Also provide what the desired results of this data would look like. According to my audit with the limited amount of data I tested it with, I think I am good.