help me to use countifs

[iRasim]

Have a good day, i uploaded a sample excel file. please help to use countifs as in excel file.

 

[SirJB7]

Hi, iRasim!
C8: =SUMAPRODUCTO(($A$2:$A$5=$B8)*($C$2:$F$5=1)) -----> in English: =SUMPRODUCT(($A$2:$A$5=$B8)*($C$2:$F$5=1))
D8:
=SUMAPRODUCTO(($A$2:$A$5=$B8)*($C$2:$F$5<>1))-----> in English: =SUMPRODUCT(($A$2:$A$5=$B8)*($C$2:$F$5<>1))
Copy down.
Regards!

 

[NARAYANK991]

Hi ,

What is the expected output in cells C8 , D8 , C9 and D9 ?

Narayan