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.
![]()
Please Login or Register to view this content.
Bookmarks