sumif function across multiple sheets
I am trying to build a roll up sheet that pulls criteria from multiple sheets, into one master document. I keep having an issue when I update the formula range from one sheet, it updates all the ranges when I don't want it to do that.
Here is an example:
For each FFE column, I have a formula specific to each Item group (ie: duvet cover) . I want to total those up from each sheet (SEA FFE for example) into each specific row, and then copy that formula over to the next column (ie. BOS 2 FFE) and have it update the ranges. However, when I copy over the formula and update the ranges, it updates ALL of them on the sheet. It seems crazy that I would have to manually update each cell when i should just be able to update the range to find the next FFE sheet (MIN, KC, and beyond).
Help Article Resources
Check out the Formula Handbook template!