+ Reply to Thread
Results 1 to 4 of 4

Staff Scheduler one more issue

  1. #1
    Registered User
    Join Date
    03-08-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    14

    Staff Scheduler one more issue

    Thanks to dredwolf for helping me with with my last issues with this. Just when I thought I had this all wrapped up and ready to roll out I was asked to add in one more piece which has me just perplexed to get working.

    I was asked to add in a piece that would let department leaders manage budgeted hours on a daily basis in a facility with variable budgets based on census.

    I have tried sumproduct, countif, countifs, counta and sum(countif) and just can't get it right

    With cooks for example ....if the position numbers listed in the range of d32:d40 appear in d9:d18 then I need it to add the corresponding number of hours that are in J32:J40 in cell d45.

    So if in range d9:d18 positions 1, 2 and 7 are scheduled for the day then d45 should total out to 29 (8.5 hours for positions 1 & 2 and 12 hours for position 7) I've either gotten a #value error a #n/a error, no value at all or a 0. I left my original formulas in place to show where my thinking was going and I'm sure it's probably a simple solution but it's escaping me.

    Anyone have any ideas I would love to hear them and always thanks to all of you out there that are way better at this than I am
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-20-2013
    Location
    Hangzhou, China
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Staff Scheduler one more issue

    Try a formula like this

    Please Login or Register  to view this content.
    Fill in the middle of course.

    -Taylor

  3. #3
    Registered User
    Join Date
    03-08-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Staff Scheduler one more issue

    This helped me immensely thank you so much it's doing what I need it to do now

  4. #4
    Registered User
    Join Date
    03-20-2013
    Location
    Hangzhou, China
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Staff Scheduler one more issue

    No worries, happy computing!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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