SumIfs Update between two tables

**birdmannn** · 01-01-2016, 06:13 PM

Hi everyone,

I have written a VBA code that is supposed to update one table by referring to another table on the same sheet. I have used the SumIfs formula since I have 2 columns taken as decisive basis for the allocation of data (Att1 to Att4). What I basically want to achieve is that the first two columns of each table are compared and if a match is found, I want this macro to build a sum of those elements in the corresponding row.

My code is:

Please Login or Register  to view this content.

The excel-file is attached. Could anybody tell me what's wrong with my code?

Thank you very much in advance! SumIfs Update.xlsm

**dflak** · 01-05-2016, 06:03 PM

I am not sure exactly what you want. I'm guessing you want to summarize A-D and D-A, etc.

What I did in the attachment was make a composite key using the formula:=IF(A2<B2,A2&":"&B2,B2&":"&A2). This formula concatenates the first two columns in alphabetical order. Then I applied a pivot table to using the composite as a row header.