Multi-sheet inventory reconciliation
IntermediateInventory reconciliation often means pulling counts from several tabs into one control sheet so you can spot shortages and overages before they affect purchasing or reporting.
SUMIF adds values that meet a condition. In a reconciliation workbook, that condition is often a shared code such as an SKU, while the values being added live on another tab.
Each warehouse keeps its own SKU list on a separate sheet: Warehouse A, Warehouse B, and Warehouse C. On Reconciliation, use the SKU in column A to pull the matching quantity from each warehouse into C2:E9, then complete F2:F9 so each row shows the combined count you can compare against the expected total in column B.
Cross-sheet formulas place the sheet name before the referenced range. A generic example is =SUMIF('Depot 1'!A2:A20, H2, 'Depot 1'!B2:B20).
Set up the warehouse formulas so they copy down cleanly across all listed SKUs. Once the actual totals are in place, any SKU whose count does not match column B is a shortage or overage worth investigating.
Need some help?
Hint 1
All three warehouse formulas use the current row's SKU as the matching condition. The parts that change are the sheet name and the quantity range being summed.
Hint 2
Because the warehouse sheet names contain spaces, each sheet reference needs single quotes. If you plan to fill the formulas down, keep the source ranges fixed while the SKU reference moves by row.
Hint 3
Once the three warehouse quantity columns are populated, the last column should add them up into that row's combined warehouse count.
Multi-sheet inventory reconciliation
IntermediateInventory reconciliation often means pulling counts from several tabs into one control sheet so you can spot shortages and overages before they affect purchasing or reporting.
SUMIF adds values that meet a condition. In a reconciliation workbook, that condition is often a shared code such as an SKU, while the values being added live on another tab.
Each warehouse keeps its own SKU list on a separate sheet: Warehouse A, Warehouse B, and Warehouse C. On Reconciliation, use the SKU in column A to pull the matching quantity from each warehouse into C2:E9, then complete F2:F9 so each row shows the combined count you can compare against the expected total in column B.
Cross-sheet formulas place the sheet name before the referenced range. A generic example is =SUMIF('Depot 1'!A2:A20, H2, 'Depot 1'!B2:B20).
Set up the warehouse formulas so they copy down cleanly across all listed SKUs. Once the actual totals are in place, any SKU whose count does not match column B is a shortage or overage worth investigating.
Need some help?
Hint 1
All three warehouse formulas use the current row's SKU as the matching condition. The parts that change are the sheet name and the quantity range being summed.
Hint 2
Because the warehouse sheet names contain spaces, each sheet reference needs single quotes. If you plan to fill the formulas down, keep the source ranges fixed while the SKU reference moves by row.
Hint 3
Once the three warehouse quantity columns are populated, the last column should add them up into that row's combined warehouse count.