Forum Discussion

DeFacto's avatar
DeFacto
Copper Contributor
Jul 23, 2022
Solved

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.

Resources