i am looking how to create a count when A2-A4 contain number 5 in each cell and A5-A7 contains number 7
then in B2,B4,B6 contain text std and B3,B5,B7 contains text prem
need a count that gives me when 5 =std and 5=prem and 7=std and 7 = prem
solution i need to get 2 is 5 std = 2
5 prem =1
7 prem =2
7 std =1
any help please