+ Reply to Thread
Results 1 to 2 of 2

Pulling values of specific cells based on corresponding dates?

  1. #1
    Registered User
    Join Date
    12-14-2011
    Location
    Australia
    MS-Off Ver
    Office 2010
    Posts
    7

    Pulling values of specific cells based on corresponding dates?

    Hi,

    I am trying to organize, on a separate sheet, all of my contracts that end within specific months. I am trying to use the numeric values that Excel assigns to specific dates within a range, but I'm not sure how to build the formula to pull the values from Sheet 1, column C based on the range. I am trying to compile this for each month of 2012 onto sheet 2.

    See attached with the numeric values, but it's not working.
    /RWL
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    Kuwait
    MS-Off Ver
    Office 365
    Posts
    2,200

    Re: Pulling values of specific cells based on corresponding dates?

    Use SUMIFS,

    Sheet2!B2, copy across.

    =SUMIFS(Sheet1!$C:$C,Sheet1!$D:$D,">="&B$1,Sheet1!$D:$D,"<="&EOMONTH(B$1,0))
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

+ Reply to Thread

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