Forum Discussion
DeFacto
Jul 23, 2022Copper Contributor
Count the columns which have cells with specific text and meet the comparison condition
Hello,
Lets say i have a table like that:
I need to get a count of columns where line #1 contains "LB" and cell in line #2 is greater or equal to cell in line #3. In this particular case the answer would be 2, as column D contains "LB" and D2 >= D3 + E contains "LB" and E2 >= E3.
I did try formulas like that with no luck:
Thank you in advance.
After i filter the range according to the comparison condition, i counted how many cells we have. Then i divided it by rows number.