I have been looking at this one for a while, still not sure why it works on
the test data... :-) As I said before, in the real data it fails, if I set
the month check to a column reference I get #NUM, when I do column
references for the Match, I get 0 (zero).

Thanks for the good ideas...

"Teethless mama" wrote in message
...
=SUMPRODUCT((ISNUMBER(MATCH(B1:K5,{4,5},0)))*(A1:A 5="Month1"))

=SUMPRODUCT((ISNUMBER(MATCH(B1:K5,{4,5},0)))*(A1:A 5="Month2"))