Restaurant Schedule Using SUMPRODUCT & COUNTIF Formula. Almost Done so PLEASE ADVISE!!

Please see the attached excel file which is a schedule for my quick service restaurant. I am trying to identify how many shifts of each job position are during lunch rush and dinner rush. You will notice that I have to break full time and part time up so I can make sure I have every position scheduled, which does not appear to be the best way to do this. Is there a way to have the COUNTIF formula correlate with the results from the SUMPRODUCT formula? I want to be able to easily identify how many of each position we have during lunch rush and dinner rush. No need to know all of the other time frames that were utilized for the SUMPRODUCT formula because if we have the positions covered for lunch and dinner rush, it will cover all of the other time frames due to the way the shifts are scheduled. If you think there is a better way to do this please share. Thanks and I need to wrap this schedule up ASAP as we are opening in two weeks!

Hello
Try offsetting the Position argument in the SUMPRODUCT function, for example does this work for the Full Time Lunch Rush in D53:D57?

Formula:

Please Login or Register  to view this content.

This returns: 2, 3, 1, 0, 1. for Monday and Tuesday: 2, 3, 0, 1, 1.

Test is out further to see if it's working correctly.

DBY

Thank you for your response. I cleaned up the spreadsheet and now this should give you a clear idea of what I am going for. I think your formula works for lunch rush (I extended it to include all shifts), but it is not working correctly for dinner rush. Attached is the updated spreadsheet so I'm looking forward to what you come up with. Thanks!

You just need to adjust the cell references for the Dinner Rush columns. See the attached revised workbook. Does this return the correct values?

This is perfect. Thank you!