Count numbers in columns

SHEET1:

In G2 and then copied down:
=IF(D2="W","N/A","")

In J2 and then copied down:
=IF(COUNTIF(D2:I2,"W")>0,"N/A","")

In M2 and then copied down:
=IF(COUNTIF(D2:L2,"W")>0,"N/A","")

SHEET2:
Changed A2:A17 and used a custom number format so the only thing actually in that cell is numbers 1-16. This allows the formulas to follow to use these cells as reference.

In C2 and copied down:
=SUMPRODUCT(--(Sheet1!$C$2:$C$600=$A2),--(Sheet1!$D$2:$D$600<>"N/A"))

In D2 and copied down:
=SUMPRODUCT(--(Sheet1!$F$2:$F$600=$A2),--(Sheet1!$G$2:$G$600<>"N/A"))

In E2 and copied down:
=SUMPRODUCT(--(Sheet1!$I$2:$I$600=$A2),--(Sheet1!$K$2:$K$600<>"N/A"))

In F2 and copied down:
=SUMPRODUCT(--(Sheet1!$L$2:$L$600=$A2),--(Sheet1!$M$2:$M$600<>"N/A"))

In L2 and copied down:
=SUMPRODUCT(C2:F2*$C$28:$F$28)


Sheet attached, I've colored all the cells I changed.