Afternoon all, I need to count a range, for example C12:C200 only if the text in those cells is greater then 5.
I had tried, COUNTIF(C12:C200,LEN(C12:C200)>5) as an array but it generates 0 when I know the amount should be 7
Any ideas please
I had tried, COUNTIF(C12:C200,LEN(C12:C200)>5) as an array but it generates 0 when I know the amount should be 7
Any ideas please