+ Reply to Thread
Results 1 to 5 of 5

Help Summing Two Fields With Identical Dates

  1. #1
    Registered User
    Join Date
    09-20-2016
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    3

    Help Summing Two Fields With Identical Dates

    I have a table where I need to add two cells (D4 and D5) when dates are identical (in this case 12-6-2013 to 1-8-2014).

    Capture.PNG

    I would like to create a new table that looks like the second image (not necessarily in the same cells).

    Capture2.PNG

    I had thought that VLOOKUP and an IF statement could help, but I'm not sure how to work it out. Hoped someone could point me in the right direction.

    Thanks.

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Help Summing Two Fields With Identical Dates

    What about a pivot table?

  3. #3
    Forum Contributor
    Join Date
    10-30-2014
    Location
    England
    MS-Off Ver
    2007 / 365
    Posts
    279

    Re: Help Summing Two Fields With Identical Dates

    Best thing is to make a copy of your table dates and then use the remove duplicates function on the Data menu to get only one instance of each row for your new table.

    Then use a SUMIFS function =SUMIFS( D:D , A:A , FromDateCell , C:C , ToDateCell )

    If your new table is in the same columns you will need to limit the above to cell ranges rather than the entire columns eg. D:D would be D1:D13 etc.

  4. #4
    Registered User
    Join Date
    09-20-2016
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    3

    Re: Help Summing Two Fields With Identical Dates

    63falcondude, I really should bone up on Pivot Tables. I'm not very familiar with them, but thanks for the reminder that I should get to be.

  5. #5
    Registered User
    Join Date
    09-20-2016
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    3

    Re: Help Summing Two Fields With Identical Dates

    Thanks EchoPassenger this worked perfectly.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Loop through fields with identical names and retrieve the value
    By Enjoylifetothemax in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2016, 07:06 AM
  2. Identifying and summing sections of columns with identical data?!?
    By Tilly13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2013, 03:18 PM
  3. Summing pivot fields where value is 1
    By Leanne_B in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 05-14-2013, 02:00 PM
  4. Summing two fields.
    By phillykyle in forum Excel General
    Replies: 5
    Last Post: 05-18-2012, 04:49 PM
  5. Charts and entries with identical fields
    By Doctor Klaproth in forum Excel General
    Replies: 1
    Last Post: 06-03-2010, 03:21 PM
  6. merge identical fields and generate totals.
    By apeman1977 in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 03-18-2009, 11:30 AM
  7. Summing with identical Vlookup values
    By kanuvas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2005, 06:36 AM

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