Forum Discussion
ignoring 0 and nesting in if
Ok so I am dealing with two problems =RANK(B3,$B$3:$B$23,1) - ( COUNTIF($B$3:$B$23, "<"&B3)- SUMPRODUCT(($B$3:$B$23<B3)*1/COUNTIF($B$3:$B$23,$B$3:$B$23)) ) I've been working on a project for quite s...
Hi Thomas,
If i understood correctly what do you mean under zero ignoring you may substruct number of zeros from your result, other words add to the end of your formula
-COUNTIF($B$3:$B$23,0)
And to add condition could be something like
=($A$1=2)*(<your formula>)
Hi I understand where your coming from but the problem is that the list I am applying this to won't always have the same number of 0's as it is a dynamic list.