It may give you more of the information you're asking about if you look at
the post I just made to T. Valko. Pleaase let me know.
--
Sociopath


"Héctor Miguel" wrote:

hi, !

not sure i'm following you correctly -?-
assuming in your range [G3:30] are at lest two TRUE (real true values)
and you need to count (from bottom to up) how many "non-true" cells...

array-entered formulae (ctrl + shift + enter)

op1: =sum(large(if(g3:g30,row(g3:g30)),{1;2})*{1;-1})-1
op2: =large(if(g3:g30,row(g3:g30)),1)-large(if(g3:g30,row(g3:g30)),2)-1

sorry if i don't undestand your complete scenario

hth,
hector.