Results 1 to 5 of 5

=SUMIF to sum from last row with data to the 2nd cell

Threaded View

  1. #1
    Registered User
    Join Date
    01-09-2012
    Location
    here
    MS-Off Ver
    Excel 2003
    Posts
    68

    =SUMIF to sum from last row with data to the 2nd cell

    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)"
    Last edited by daillest319; 05-24-2012 at 01:35 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1