+ Reply to Thread
Results 1 to 2 of 2

if 1 column = date range, take next cell value and sum in a 3rd cell on 2nd page

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    Virginia Beach, VA
    MS-Off Ver
    Excel 2010
    Posts
    2

    if 1 column = date range, take next cell value and sum in a 3rd cell on 2nd page

    I have a spreadsheet where I am compiling data for my mortgage loans at work. I also have bar graphs working off the inputs on page 2. I have a "funded date" column, next to it a "points" column and on the 2nd page a cell for every month of the year. I want to be able to have it search the "funded date" column for specific date ranges comparable to each month (like 11/1/12 - 11/30/12, or 12/1/12 - 12/31/12) and if its in that range, then take the value in the next cell and add it to a separate cell on page 2. Any help would be greatly appreciated. Thank You!!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-14-2012
    Location
    Brooklyn, NY
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: if 1 column = date range, take next cell value and sum in a 3rd cell on 2nd page

    Please see attachment is this what you wanted? (please note the formulas in 2nd sheet column 'A', you can highlight it white it should be invisble)
    Attached Files Attached Files

+ 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