Counting specific values across multiple sheets

Hi Everyone,

I am pretty new with excel. the situation is that I have several different electrical fixtures, all with varying configurations, each with it's own sheet. I have managed to set up each sheet so that the various configurations are compiled for each component that's needed for the fixture. This means that I will have a lot of variation for each fixture. I need to be able to count all of the different combinations onto the Materials sheet so that I can have a count on all of the specific combinations.

Any help would be greatly appreciated

Hi
can you add manually the expected results on the "Material List." tab?

There will be a lot of variation between fixtures, making that difficult.

I'm confused. Why would you submit a sample sheet with all sheets being identical?

Is the "Quantity" on your "Material List" sheet equal to the value in A6 in the Fixture sheets? Given your workbook, should the Material Sheet show quantity of 72 and the Fixture Type show "EM Fixture" for 8 rows?