Hi Team,
Weird one this. I have set my formula to this: =(countif(C3:AI3,"*")/(AJ3)*100) and it works.
However I want it the other way round: =(AJ3)/(countif(C3:AI3,"*")*100) and it comes as 0, whereas it should be 100
Tell me doing something stupid!?
Thanks
Matt
Weird one this. I have set my formula to this: =(countif(C3:AI3,"*")/(AJ3)*100) and it works.
However I want it the other way round: =(AJ3)/(countif(C3:AI3,"*")*100) and it comes as 0, whereas it should be 100
Tell me doing something stupid!?
Thanks
Matt