Try
=SUMPRODUCT((ISNUMBER(SEARCH("1",$C$1:$C$12)))*(MONTH($A$1:$A$12)=2))
Change "1" to "abc" and "yyy"
Try
=SUMPRODUCT((ISNUMBER(SEARCH("1",$C$1:$C$12)))*(MONTH($A$1:$A$12)=2))
Change "1" to "abc" and "yyy"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks