mix if and mid

  1. T

    Mix IF and MID

    Hi, Can I mix IF with MID command? I am trying a formula which is not working the way it should. Can you please help me ? Q16 = 1, 0, 3, 7, 2 (I will have numbers between 1-9 in random order) I want to count all numbers above 1 (I dont want SUM). In this case I want result to be 4. (By...

Some videos you may like

This Week's Hot Topics