Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Calculating Days In Cumulative Between Categories.

    Hi

    I have a question that how I can Calculating Days in Cumulative between Categories, please check the attached file.

    with Regards
    MAM
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,224
    Thanks
    14
    Thanked 341 Times in 334 Posts
    Will 2 pivot tables work like in the attached?

    Steve
    Attached Files Attached Files

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,184
    Thanks
    201
    Thanked 781 Times in 715 Posts
    MUSA,

    Or using SumIFs
    MUSA3299.xlsx
    Notes:
    1. I changed your format slightly to use Month Nos vs dates. ( I couldn't get SumIfs to work with dates for some reason?)
    2. I added the length of day field since I didn't know if you wanted 8 hour work days or 24 hour days?
    3. I assumed the 1st calculation was ALL hours not just "Ys".
    musa.JPG
    HTH
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


Posting Permissions

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