+ Reply to Thread
Results 1 to 6 of 6

Adding cells that are in a specified date range

  1. #1
    Registered User
    Join Date
    05-01-2012
    Location
    Doha, Qatar
    MS-Off Ver
    Excel 2007
    Posts
    13

    Question Adding cells that are in a specified date range

    Dear All,

    I'm a new user on excel and facing a problem which I cannot seem to find an answer to. I have a workbook with two sheets, on the first sheet I have a list of numbers in one column and a list of dates in the next column. In the second sheet I want to sum the cells which meet a specified date range which I input. For example, if I put on sheet2 start_date 01-01-2012 and end_date 30-01-2012 it should sum the cells from sheet1 within this range. How do I do this? please help, my boss is asking me to do this.

  2. #2
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: Adding cells that are in a specified date range

    Perhaps:

    =SUMIFS(value_range,Date_range,">=start_date",Date_range,"<=end_date")
    Sincerely
    S?ren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

  3. #3
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Adding cells that are in a specified date range

    Hi and welcome to the forum.

    Try this

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  4. #4
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Adding cells that are in a specified date range

    Assuming A1:A4 has your dates and B1:B4 has the numbers you want to sum:
    =SUMIFS(B1:B4,A1:A4,"<="&EndDate,A1:A4,">="&StartDate)

    Pauley

    Wow, two other replies while I was typing out my solution. BTW, the EndDate and StartDate are named cells. Change to the cell location of your date range values (e.g. B5, or whatever).
    Last edited by Pauleyb; 05-01-2012 at 09:02 AM.

  5. #5
    Forum Contributor
    Join Date
    01-24-2011
    Location
    Sheppey
    MS-Off Ver
    Excel 2010
    Posts
    239

    Re: Adding cells that are in a specified date range

    See attached sheet
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    05-01-2012
    Location
    Doha, Qatar
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Adding cells that are in a specified date range

    Thanks BarryTSL, and thanks to all the guys that helped. My problem is solved and my job is safe

+ Reply to Thread

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