+ Reply to Thread
Results 1 to 2 of 2

formula to retrieve cell depending on date within another column?

  1. #1
    Registered User
    Join Date
    10-24-2010
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    32

    formula to retrieve cell depending on date within another column?

    Hi there,

    I am having a bit of trouble with how to do this.

    I basically have a spreadsheet with lots of data in each column.

    In one of the columns (H:H) , there is a date and then another column (J:J) there is a value I want to retrieve.

    So an example would be H1 to have 01/01/01 and J1 to have the number 5
    H2 would have 01/01/01 and J2 would have 4


    How would I go about doing something so that it would be like - Add together all the digits within the J column if the H column cell had the date between like 01/01/11 - 31/01/11

    I think it is a sumif

    so it would be like finding the cells with the dates between 01/01/11 and 31/01/11 and then looking across seeing what is in the same row underneath the J column and then adding them altogether.

    Thank you

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: formula to retrieve cell depending on date within another column?

    Give us a clue...
    Post a workbook with what you have so far, showing your Sheet Layout and perhaps Before and After examples.

    It should clearly illustrate your problem and not contain any sensitive data.

+ 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