Match and CountIF Across Multiple Sheets Using Formula

[khateeb]

I need assistance, please provide a sample working formula... this is the range of sheets described as date [Data validation]... E3: E33... my range is E3:E14 for all the sheets (that is Date1 --E3 to Date31 E33..])... matching up for I3: I14 for MF8330 and summing up in summary2...Please check the attachment.

MF8330 black compare and add from all sheets for only building 1.1.1
MF8330 Cyan Compare and add from all sheets for only building 1.1.1
Similarly for other2 colors.

Please check the attachment.

[Excel Fox]

Make a list of all the required sheets in a sheet, and give the range a name > List

Alternatively, instead of creating a list by given a range reference, you could also do so like this ={"Date1","Date2","Date3"}

Then, in the summary sheet, in B14, use

=SUMPRODUCT(COUNTIF(INDIRECT("'"&ListAlternate&"'! "&ADDRESS(MATCH(B$13,INDIRECT("Date1!$I$1:$I$14"), 0),MATCH($A14,Date1!$A$2:$H$2,0))),"yes"))

and drag down.

Check the attachment

[khateeb]

I have put this formula and even checked the excel, still it is not working. Please advise. Thanks

[Excel Fox]

The printer model column (Column I) should have the exact same order of printers in all the sheets. Without that, it will not work (unless there's a better formula that can do the vertical match for all sheets).