Counting text occurrences by week

[KFitz]

Hello,
I am trying to compare the amount of "OPEN" slots there are in a given week with the amount of items that need to be worked on.
The way I've approaching this so far, with no success, is to assign a given date a week number (using weeknum function). Then tried the countif and sumproduct functions to see how many times the text "OPEN" is associated(in same row) with that week number. Then later compare the number of entry's (in the queue column) with the same week number. So count the number of times OPEN occurs in a given week and compare that with the number of samples created in a given week.

So column A is a chronologic date, column B is a text column containing the text "OPEN" (or some other text) indicating if a sample can be tested in morning on that day. Column C is the same text column indicating if an "OPEN" slot exist on that date in the afternoon on that day. Column D is the date the sample enters the queue and Column E is the sample identifier. I'm trying to see if the number of "OPEN" slots is smaller than the number of samples entering the queue for a given week.
I know my way around a few basic formulas in excel but haven't been able to figure this out. I hope I have explained myself enough for you to help me.
Thanks in advance

[zbor]

can you upload example?

[KFitz]

I added an attachment example. I was hoping to create a basic capacity planning tool. So that when more samples are submitted (or are going to be submitted) in a given week than there are slots OPEN then action is taken

[FrankS]

How about this?

[KFitz]

That might do the trick thank you, Frank S. Unfortunately some of its in german and I don't know much german. do you know of a way to convert the text to english? Its not all of the text just some of it.

[KFitz]

Actually I think I can figure out the translation but don't know how you were able to automatically insert a row where the week ended. that seems to be were you sum up the open slots per week. But often the rows for the incoming won't always be the same week as the lab processing date. so you will sum up open slots over 2-3 different weeks vice versa. I apperciate the attempt and I might be able to use the idea. thanks
Kris

[FrankS]

Use the function "partial result" in menu "data" to make groups and insert rows automaticaly.