Hi Excel Experts,
I have attached the spreadsheet here: Combined-Inventory.xlsx
Inside you will see several sheets (I am only referring to the combined
sheets for this question).
Looking at column F you will see that I have a SUM there at the bottom. It is different from my SUM on the other sheet.
I don't know why the SUM's are different. Basically, I need to find the ITEM ID (PLU) that isn't being counted in the combined sheet. Why do I have a variance?
Can someone help me locate why the two sheets SUMS are different?