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
Bookmarks