I suspect that a sumproduct formula is what is heavily weighing down a sheet i have. I have attached a sample that has only 3 rows however the real document has thousands. Does anyone have an idea of a better, more efficient formula I can use? The cells with the sumproduct formula are highlighted blue.
The goal of the replacement formula:
For each item, add up the total for each week from the inventory sheet. For example, the total for cheese is 600 in week 1 because it is listed two times with on the inventory sheet with 200 and 400 so (200+400 = 600).
Hopefully that makes sense...
Thank you in advance to anyone who responds.
Bookmarks