Hi
I have sheets(TTR,TMP,TSB) contains items in column B should match based on it . the sheet TTR contains values in column I,J and the sheet TMP,TSB contains values in column H .so what I want to sum the values for sheets TTR,TMP for column I with column H and sheets TTR,TSB for column J with column H based on matching the item in column B . the result should be in sheet OUTPUT contains item in column B should match with the others sheets and brings values to columns K,L after summing as I have ever mentioned .
notice: there are many duplicated items whether in the same sheet or also across sheets , then should merge across based on column B sheets .
thanks
I have sheets(TTR,TMP,TSB) contains items in column B should match based on it . the sheet TTR contains values in column I,J and the sheet TMP,TSB contains values in column H .so what I want to sum the values for sheets TTR,TMP for column I with column H and sheets TTR,TSB for column J with column H based on matching the item in column B . the result should be in sheet OUTPUT contains item in column B should match with the others sheets and brings values to columns K,L after summing as I have ever mentioned .
notice: there are many duplicated items whether in the same sheet or also across sheets , then should merge across based on column B sheets .
thanks