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?
Try this version
=SUMPRODUCT((TEXT($B$172:$B$198,"mmm;;")=TEXT(AW$11,"mmm;;"))+0)
Audere est facere
That's perfect! Thanks!!!
Here's another one...
Array entered**:
=SUM(IF(ISNUMBER($B$172:$B$198),IF(MONTH($B$172:$B$198)=MONTH(AW$11),1)))
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Let's go Pens!
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks