Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2014
    Posts
    2
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Lookups/Summing in Workbooks

    Hi,

    I'm hoping for some assistance - and I don't even know if this can be done....But here is what I want to do:

    Sheet 1 of a workbook is a summary page and I have dates listed in order in column A. So, I want a formula in column B to look at this date in column A. I then want it to go to another sheet in the same workbook (say sheet 2), look in column A (which will also be a date range). If it finds a match, I then want it to go to another column in sheet 2 (say column C), and sum the values/amounts where the dates match, otherwise, it is a zero.

    I've tried all the permutations I can think of with the lookup, sum formulas, etc and I may even be in the wrong thought zone, but I just can't seem to get anything to work. It is possible there are other threads in this forum, but I canít locate them. And, as there are much more intelligent people than me on this forum, I'm hoping someone can help. Any assistance would be greatly appreciated.

    Thanks in advanceÖ.

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts
    Welcome to the lounge.


    In column B on Sheet 1, try: =SUMPRODUCT((A1=Sheet2!$A$1:$A$20)*Sheet2!$C$1:$C$ 20)

    Change the range (currently row 20) to however many rows you have in sheet2.

    Fill this formula down in Sheet1.

    Hope this is what you wanted.

  3. The Following User Says Thank You to kweaver For This Useful Post:

    dcarroll71 (2014-07-16)

  4. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,629
    Thanks
    114
    Thanked 644 Times in 588 Posts
    dcarroll,

    As an alternative: =SUMIF(range,criteria,sum_range)

    Cell B1 =SUMIF(Sheet2!$A$1:$A$30,Sheet1!A1,Sheet2!$C$1:$C$ 30) and drag down

    sumif3.png

    sumif4.png

    HTH,
    Maud
    Last edited by Maudibe; 2014-07-16 at 18:37.

  5. The Following User Says Thank You to Maudibe For This Useful Post:

    dcarroll71 (2014-07-16)

  6. #4
    New Lounger
    Join Date
    Jul 2014
    Posts
    2
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thank you so much to both of you (kweaver & maud) for your help. Both options work so that is terrific. Thumbs up to both of you.....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •