I'm sure there is a solution to the following problem however I can't seem to find it. Hopefully someone will be kind enough to guide me in the proper direction.
Basicly I have a sheet which is setup something like below and I want to sum the volumes from company 1 and company 2 aswell as total volumes of each product which is fine until I have a need to resort the sheet after I resort the sheet the totals are adjusted to reflect the new value of the cell range I have in my formula. How do I create a formula that will maintain the correct result regardless of how I sort the data?
DATE Company Product Volume
oct 11 company1 product1 6
oct 12 company2 product1 4
nov 21 company1 product1 5
Bookmarks