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

[James09]

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

James

[#2]

@James09 , use numbers, not texts

=IF(COUNTIFS(B4:W4,"np"),1,0)

[#3 · Accepted solution]

@James09 , or, as variant

=--(COUNTIFS(B4:W4,"np")>0)

double dash converts logical to number

[#4]

@Sergei Baklan 

Fantastic,

Thank you Very Much I had no idea

James