Forum Discussion
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? ...
Please use this formula
=IF(SUM(COUNTIFS(P3:Z3,{"x","N/a"}))=11,"Completed","Incomplete")
Some cells will have N/a since they do not applied to specific people.
I would like the "x" and "n/a" to mark the New Hire Documents column with Complete. Is that possible?
Ive attached screenshot.
Please use this formula
=IF(SUM(COUNTIFS(P3:Z3,{"x","N/a"}))=11,"Completed","Incomplete")