Excel- SUM function not working with =IF(COUNTIFS function

Hi I am trying to find the Sum of a column that has given me the output of either 0 or 1 using the formula =IF(COUNTIFS(B22:W22,"np")*1,"1","0")- I have attached the Excel spreadsheet   Many Thanks...