May 29 2019 12:55 PM
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
May 29 2019 01:16 PM
@James09 , use numbers, not texts
=IF(COUNTIFS(B4:W4,"np"),1,0)
May 29 2019 01:20 PM
SolutionMay 29 2019 01:36 PM
May 29 2019 01:20 PM
Solution