Results 1 to 6 of 6

Sorting Dates Column and calculating MTD, YTD

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-13-2009
    Location
    London, England
    MS-Off Ver
    Excel XP
    Posts
    174

    Sorting Dates Column and calculating MTD, YTD

    Hi guys,

    What I'm looking for is good ole fashioned formula-help on this one, no fancy-macro required unless you're feelin' generous hah.

    So Column 1 I've got dates, need to sort through that and calculate Year-to-date and Month-to-Date values. These are both Sums of the cells....
    YTD = Sum of all cells with most recent yr, in this case 2007
    MTD = Sum of all cells in Column B for most recent month, Feb2007 here.

    I've listed the desired solution for YTD and MTD on the sheet as well

    (I'm guessing the solution will have something to do with SUMPRODUCT?)
    Thanks in advance, i know its gonna be peanuts for some of you pros here
    Attached Files Attached Files
    Last edited by Pasha81; 11-10-2009 at 09:05 AM.

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