Forum Discussion

James09's avatar
James09
Copper Contributor
May 29, 2019
Solved

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...
BI & Data Analysis
excel
Formulas and Functions
  • James09's avatar
    James09
    Copper Contributor
    May 29, 2019

    SergeiBaklan 

    Fantastic,

    Thank you Very Much I had no idea

     

    James

Resources