Forum Discussion
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? is that possible?
Please use this formula
=IF(SUM(COUNTIFS(P3:Z3,{"x","N/a"}))=11,"Completed","Incomplete")
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")
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")
YES! that worked Thank you!!!
- You are welcome.
