what i'm trying to do is use this formula =SUMIF($G$2:$G$13,"1,K2:K13) based on the two coulmns.
so i want to find both columns and calculate the total at the bottom of the AMT Column and the dup coulms will have 1 and 0 that to sort out the dups but the thing is the amount of rows is always different.
Set FoundD = Rows(1).Find(What:="Dup", LookIn:=xlValues, LookAt:=xlWhole)
myCol = WorksheetFunction.Match("AMT", Rows("1:1"), 0)
LR = Cells(Rows.Count, Found2.Column).End(xlUp).Row
Range(Cells(2, FoundD.Column + 1), Cells(LR, FoundD.Column + 1)).FormulaR1C1 = "=SUMIF($G$2:$G$13,"1,K2:K13)"
Bookmarks