Forum Discussion

Hursh Patel's avatar
Hursh Patel
Copper Contributor
Apr 04, 2018
Solved

Need help with formula

I have this Formula inputted into my spreadsheet but I also want it to state if the cell has N/a to mark complete.   =IF(COUNTIF(P3:Z3,"x")=11,"Completed","Incomplete")   How do you do that? ...
Formulas & Functions
Tutorial
  • Jamil's avatar
    Jamil
    Apr 04, 2018

    Please use this formula

     

     

    =IF(SUM(COUNTIFS(P3:Z3,{"x","N/a"}))=11,"Completed","Incomplete")

Jamil's avatar
Jamil
Bronze Contributor
Apr 04, 2018

This will work for you.

 

so if the cells in your range P3:Z3  either will have x or N/A then completed otherwise not completed

 

=IF(SUM(COUNTIFS(P3:Z3,{"x","N/A"}))=11,"Completed","Incomplete")

Hursh Patel's avatar
Hursh Patel
Copper Contributor
Apr 04, 2018

YES! that worked Thank you!!!

  • Jamil's avatar
    Jamil
    Bronze Contributor
    Apr 04, 2018
    You are welcome.