Count if Results

[Brew]

How do I count the number of time the record result is greater than 20 in the list t4:t1003?

 

[Brew]

Glenn, I Inserted the function and the formula and now my result is 1000, rather than 2. What do I do now?

 

[GlennUK]

Can you show the contents of, say, the first 4 cells, as they appear in the formula bar, of the range you are testing, please?

 

[Brew]

My apologizes, the range is u4:u1003 and not in the T column.
Also, when I change the formula to =countformulaegt(U4:U1003,20)
the function code gave a result of 230, the desired result should be 5.
Below are the cell contents in the formula bar:

cell contents
u4==IF(T4="Y","x",IF((T4="N")*(T2="Y"),1,U2+1))
u5==IF(T5="Y","x",IF((T5="N")*(T4="Y"),1,U4+1))
u6==IF(T6="Y","x",IF((T6="N")*(T5="Y"),1,U5+1))
u7==IF(T7="Y","x",IF((T7="N")*(T6="Y"),1,U6+1))

 

[GlennUK]

So, you are saying that only 5 of the formulae in the range U4:U1003 have results greater than 20?

 

[Brew]

Yes, that is correct

 

[GlennUK]

I will send you a Private Message with my email address on it, 'cos I can't think of a reason for why this wouldn't work. Send me the workbook, and I'll have a look and see what's going on.