My sheet looks something like the table below, with update columns ending at O. I want to put a formula in B which will automatically label a row as complete or still needs work. The requirements are different, however, for project a/b and c. For a and b, the number of yes cells to be complete is 7. For c, it's 4 but I haven't gotten to that part yet because I keep getting a "error array arguments to countifs are of different size" error message that I don't understand. What am I missing?
=if(or(countifs(C2:O2,"done",a2,"a"),countifs(C2:O2,"done",a2,"b"),countifs(C2:O2,"done",a2,"c"))=7,"done","needs work")
=if(or(countifs(C2:O2,"done",a2,"a"),countifs(C2:O2,"done",a2,"b"),countifs(C2:O2,"done",a2,"c"))=7,"done","needs work")
A | B | C | D | E |
project | updates needed? | update 1 | update 2 | update 3 |
a | yes | yes | no | |
b | no | yes | yes | |
c | yes | yes | yes |