Good morning, I'm looking for a little help with a countif (i think) formula.
Currently: S23 - S33 contain values = to the amount of labor I need for 1 order
P23 - P33 contains values = to the start date of those orders.
Ex: Row 23 = an order, P23 = 5/24(start date of that order, S23 = 6 (number of people I need to run that order)
This is just one production line, which I have 10 of. What I am trying to do is make a table that shows how much labor I need on any give day of the week based on the values mentioned above.
Here is what I think I need, I just can't figure it out:
COUNT the labor in S23:S33 IF the date(s) in P22:P33 is equal to a Monday
I would then repeat this process for each day of the week Mon-Fri
I would also repeat it again with different cell ranges for the other production lines.
But I think once I get one solved I can copy to the rest.
Thanks in advance!!
EDIT: What I really need is the formula to reference the dates in column P - find ALL data that meets the criteria (in this case, all dates that equal monday) and then look at column S and choose the highest number.
Example
Job 1 - Mon 5/23 - 5
Job 2 - Mon 5/23 - 6
The formula would see that there are 2 Monday values (5 and 6) and then choose the greater of them, in this case 6.
THank you!
Bookmarks