I have sheet1 with consecutive dates in column A (starting with a Monday) and numeric values alongside them in column B.

Each set of seven dates from each Monday to the following Sunday is considered a block for this exercise.

In sheet2 I have a list in column A of the dates corresponding to just the Sundays from sheet1. In column B I want to have the count of the non-zero cells in column B from the corresponding block in sheet1 that ends with the corresponding Sunday date.

What formula do I need that I can copy down in sheet2 column B to get all of the counts?

Thanks!