Compare and add from all previous sheets

**khateeb** · 03-04-2013, 01:38 PM

Please advise... Sheet summary2 has the table. And I am looking to compare and add the data (from all sheets Date 1 to Date31) . I am looking to add those values (yes as 1) in my summary 2 sheet for the range E3 to H14 ...if it mathces as MF8330 or x543 or c5045 or x940.

**vlady** · 03-05-2013, 07:39 PM

try this in cell B14 Summary2

Formula:

Please Login or Register  to view this content.

look attachment
send.xlsm

**khateeb** · 03-06-2013, 03:53 AM

Hi.. !! I have checked the formula but it is adding for entire excel sheet. I would like to add it for only (1.1.1) building range E3:E14 *I3:I4... if it if yes and MF8330 in this range should be added in summary 2 table for 1.1.1 building. Similarly for 1.1.2 building checking yes from S3:S14 * and w3:w14 for MF8330 and displaying in 1.1.2 table in summary2 sheet.

**vlady** · 03-06-2013, 04:18 AM

you have to edit the range to suit the table 1.1.1 up to 1.1.2
something like

=SUMPRODUCT(N(INDIRECT("'"&INDEX('PRINTER MODEL'!E3:E33,MATCH(B2,'PRINTER MODEL'!E3:E33,0) the ranges should refer to the table you want

**khateeb** · 03-06-2013, 06:36 AM

Well, this is the range of sheets described as date... 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...
may b iam quite dump... Im not getting what you are trying to explain.