lakamas
11-12-2015, 06:21 AM
I need to replace this function:
=SUMIFS($D:$D;$A:$A;$G2;$B:$B;$H2;$C:$C;$N$1)
to VBA code and find a way to loop it so I can fill column K (based on the length of column G) of the example file with the correct sums.
14743
File details:
Columns A,B,C,D are data
Columns G,H are the criteria I need to use
Column K is where I need to fill the summed amounts from Column D based on the corresponding criteria from G and H columns and N1 value
=SUMIFS($D:$D;$A:$A;$G2;$B:$B;$H2;$C:$C;$N$1)
to VBA code and find a way to loop it so I can fill column K (based on the length of column G) of the example file with the correct sums.
14743
File details:
Columns A,B,C,D are data
Columns G,H are the criteria I need to use
Column K is where I need to fill the summed amounts from Column D based on the corresponding criteria from G and H columns and N1 value