Results 1 to 5 of 5

VBA for sumifs() with varying last row

Threaded View

  1. #1
    Registered User
    Join Date
    05-26-2011
    Location
    Overland Park, KS
    MS-Off Ver
    Excel 2007
    Posts
    13

    VBA for sumifs() with varying last row

    I thought this would be possible but I get a "Compile Error" when entering the following code:

    LastRow = Cells(Rows.Count, "DH").End(xlUp).Row
    ActiveCell.Select
    ActiveCell.Formula = _
    "=SUMIFS($DG$4:$DG$" & LastRow & ",$A$4:$A$" & LastRow & ",""Unidentified*"", _
    $DF$4:$DF$" & LastRow & ",""September 2011"")

    I am attempting a sumifs() formula that has a varying last row.

    Any help would be appreciated.

    Thanks.
    Last edited by snelson0713; 09-15-2011 at 04:10 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