=SUMPRODUCT(($a$1:$a$200>=date(2012,1,1))*($a$1:$a$200<=date(2012,1,31))*($b$10:$b$200="YES"))
should do it.
=SUMPRODUCT(($a$1:$a$200>=date(2012,1,1))*($a$1:$a$200<=date(2012,1,31))*($b$10:$b$200="YES"))
should do it.
Good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks