I have inventory issues. We have a spreadsheet used for physical inventory and there are multiple locations for some items. Worksheets are separated by location, each worksheet is by item alphabetically. I need a formula that checks the part number and gives me a total from all sheets with that part on one separate sheet. Is there a formula that will do this?
