October 18, 2018
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?
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Excel Customer Service
November 8, 2013
January 31, 2022