Results 1 to 4 of 4

Thread: Summarize Data from Dates to Months based on Criteria

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 12-30-2021, 10:57 AM #1
    msiyab
    msiyab is offline
    Member
    Join Date
    Jun 2012
    Posts
    80
    Rep Power
    13

    Summarize Data from Dates to Months based on Criteria

    Hi,

    I have a project tracker file which I need to summarize (by count) on the next sheet based on the project status.

    The tracker sheet has dates in the dd-mmm-yy format, whereas the summary sheet is month based (mmm-yy). Basically I would like to know the count of projects under different progress status in each month in the summary sheet.

    I have attached a reference file.

    Project Tracker.xlsx

    HAPPY NEW YEAR
    Last edited by msiyab; 12-30-2021 at 11:06 AM. Reason: Wrong file uploaded
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Conditional Formatting of Dates (Multiple Criteria)
    By msiyab in forum Excel Help
    Replies: 19
    Last Post: 02-14-2019, 11:53 PM
  2. Copy paste data based on criteria
    By analyst in forum Excel Help
    Replies: 7
    Last Post: 01-13-2014, 12:46 PM
  3. Summing Data based on certain criteria
    By Howardc in forum Excel Help
    Replies: 7
    Last Post: 01-30-2013, 07:12 PM
  4. The Number of Years, Months and Days Between Two Dates
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 7
    Last Post: 06-08-2012, 10:35 PM
  5. Split data based on criteria
    By Mahesh.sreekakulam in forum Excel Help
    Replies: 3
    Last Post: 06-08-2012, 09:30 PM

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
  •  

Forum Rules