Forum Discussion
Nested IF formula
In my file formula works
All Directors 2 =SUM(COUNTIF(A10,{"*Engineer*","*Expert*"}),COUNTIF(A10,{"*Director*","*Manager*"})*2) Our Managers 2 =SUM(COUNTIF(A11,{"*Engineer*","*Expert*"}),COUNTIF(A11,{"*Director*","*Manager*"})*2)did you check it?
perhaps you could attach small sample with your formulas
Hello Sergei,
The first part of the formula works but it does not manage to get the "Directors" nor "Managers". It only brings up 0.
I have managed to try out the following formula:
=SI(NB.SI(H163;"*Engineer*");"1";SI(NB.SI(H163;"*Director*");"3";"2"))
In this case, "Engineer"=1, "Director"=3 and "Neither one of them"=2.
I do not know what I am doing wrong...
thanks a lot though !
In my file formula works
All Directors 2 =SUM(COUNTIF(A10,{"*Engineer*","*Expert*"}),COUNTIF(A10,{"*Director*","*Manager*"})*2)
Our Managers 2 =SUM(COUNTIF(A11,{"*Engineer*","*Expert*"}),COUNTIF(A11,{"*Director*","*Manager*"})*2)
did you check it?
perhaps you could attach small sample with your formulas
Hello Sergei,
For some weird reason it works now :)
I just have one more question, how would you do if I want the cell to show 3 if none of the words I want appear in the chosen cell ?
Thank you very much !
Alexandre,
That could be
=CHOOSE(SUM(COUNTIF(A1,{"*Engineer*","*Expert*"}),COUNTIF(A1,{"*Director*","*Manager*"})*2)+1,3,1,2)and attached
Hello Sergei,
It works perfectly !
I cannot thank you enough !
Thank you for your time and patience !
Good afternoon to you :)