Sum a value connected to a identity across whole workbook?

[enanthate]

Hi All,

On each worksheet, I need to see how many units of something have passed through a certain machine. This is easy enough on a single sheet using SUMIF.
Is there any way to use a code to search through all the sheets in a workbook, and find the total units that a specific machine has processed?

The rows vary on the different sheets, but the columns are the same.

You can see in the example the code that is used to search for and sum the units connected to a specific machine.

example.PNG

[davsth]

I assume you have sumifs on each separate sheet. if they were in a consistent place say columns G and H to the right

If you include the first and last sheet in your formula, it will even grow if your insert new sheets inbetween

but something like
=SUM(Sheet1:Sheet3!H1)

where sheet1 is the first sheet and sheet3 is the last sheet

There are other options which are more complicated using the indirect function and name ranges
https://exceljet.net/formula/3d-sumi...ple-worksheets