I have the following formula to count the total of locations opened by month. If a center isn't going to open, the location's opening date will error and show a blank cell, but it's a calulated value. The sumproduct is =SUMPRODUCT(($B$172:$B$198<>"")*(MONTH($B$172:$B$198)=MONTH(AW$11))). Any help?
Bookmarks