Try this...
=SUMPRODUCT(--ISNUMBER(FIND(1,C$1:C$12)),--ISNUMBER(SEARCH("A",D$1:D$12)),--(MONTH(A$1:A$12)=2))
Try this...
=SUMPRODUCT(--ISNUMBER(FIND(1,C$1:C$12)),--ISNUMBER(SEARCH("A",D$1:D$12)),--(MONTH(A$1:A$12)=2))
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)
Bookmarks