Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Youngstown, OH
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a spreadsheet (drastically pared down and attached) that I use to track completion of jobs. I print out the Completion Pivot page each week on the same day every week.
    I have added the Scheduled, Completed and Percentage cells to the right of the pivot table.
    COUNTIF works fine for the Completed cell, since that date is manually entered. I'd like to automate the Scheduled cell.
    Currently I can just change the date in the formula for that cell, and it works fine. What I'd like to do is have the Scheduled cell display the number of jobs scheduled based upon the date in the Jobs Due By column of the Schedule sheet.
    The date in this column is determined by the Last Date Completed and the Freq columns on the Schedule sheet.
    I've tried various permutations of Date, Now and Sum. If I knew half of what I think I know about Excel, this might be easy...but that ain't the case
    Any help would be appreciated.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I'm not entirely sure I followed what you wanted, but is it just:

    =COUNTIF(Schedule!D959,"<="&Schedule!D4)

    ?

    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    Youngstown, OH
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yes.. that's what I need....I needed to add a D4+7 in the formula on the Completion Pivot sheet to make the report work...but exactly what I need.
    Thanks very much. Like I said, I know enough about Excel to know that I don't know enough.

Posting Permissions

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