Results 1 to 5 of 5

Sum amounts based on dates in a column range and a project # in a specific cell

Threaded View

  1. #1
    Registered User
    Join Date
    03-07-2012
    Location
    California
    MS-Off Ver
    Excel 2016
    Posts
    22

    Sum amounts based on dates in a column range and a project # in a specific cell

    On one worksheet I have a set of Dates in Column H, Amounts in Column I, and Project #'s in Column L. I want to get the sum of the project # (in column I, GL Tab) for the first quarter of the year only (based on Column H, GL tab) on the CP tab. As time goes on I will want Quarter 2,3, & 4 in separate columns on the CP tab... I have tried several formulas, but they just aren't working out. I have done sumifs, sumif, and if formulas.

    Does anyone have a suggestion? Seems like this should be easy but my spreadsheet just isn't working out. I'm going cross-eyed at this point.

    Here's the last formula I tried, but it just give's me $0.00's... I thinking my date criteria is messing things up.


    =SUMIFS(GL!$I:$I,GL!$L:$L,CAPEX!$A6,GL!$H:$H,"<=3/31/11")
    I have attached a small spreadsheet with examples. I want my formulas on the "CP" Tab, my orig data is on the GL tab.

    Any help would be appreciated.
    Attached Files Attached Files
    Last edited by Jexcel2012; 03-08-2012 at 01:25 PM. Reason: change to solved

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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