Countifs with or condition

Originally Posted by Gulya

I have attached the sample file

Thanks for that, how about

Formula:

=COUNTIF(INDEX(Data!$B$2:$K$37,MATCH(B$1,Data!$A$2:$A$37,0),0),$A2)