What you are trying to do in Assignment 6 is to have VBA calculate Monthly Sales for each of the 5 Sellers that are in cells I6:I10. Furthermore, you will calculate the TOTAL sales in cell I11. Your approach should adapt to the size of the data in this sales sheet. In other words, there are 11 rows shown in the data here (and in the starter file), yet your sub should work the same if we had 20 rows, for example, or 50 rows. The format of this sheet will always be the same (headers will be in row 5).
Next, you need to have VBA automatically calculate the Total Boxes of each of the 3 different cookies in cells I14:I16.