+ Reply to Thread
Results 1 to 6 of 6

Get the Dates in a Month?

  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    AF
    MS-Off Ver
    Excel 2007
    Posts
    5

    Get the Dates in a Month?

    Hello, can you help get the dates (without the duplicates) and some sums in this sample table for each month?

    Example:
    May 21 101 102
    May 28 101 105
    June 01 100 102
    June 01 104 102
    June 05 103 102
    June 06 102 102

    I would like to get a result like this in another worksheet:
    JUNE X Y
    01 204 204
    05 103 102
    06 102 102
    How can I get the reds by using only 1 formula for all of them?

    Thanks.
    Last edited by andsoiwas; 10-06-2012 at 11:51 AM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Get the Dates in a Month?

    See Help for the SUMIFS function.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    07-17-2012
    Location
    AF
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Get the Dates in a Month?

    Thanks, what I only know is I can do that for the those in blue, but my main problem is how to get those in red?
    (please see my newly edited table)

  4. #4
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: Get the Dates in a Month?

    See the attached
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-17-2012
    Location
    AF
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Get the Dates in a Month?

    Thanks! I'll keep this thread open for a few days just in case there are other methods our fellow members might be able to think of.

  6. #6
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Get the Dates in a Month?

    How about pivot tables..

    See attached

    A bit of reading too..
    www.cpearson.com/excel/pivots.htm
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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