SOLVED

Count the columns which have cells with specific text and meet the comparison condition

Copper Contributor

Hello, 

 Lets say i have a table like that:

cl.png

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:

clip1.pngclip2.pngclip3.png

Thank you in advance.

1 Reply
best response confirmed by DeFacto (Copper Contributor)
Solution

@DeFacto 

After i filter the range according to the comparison condition, i counted how many cells we have. Then i divided it by rows number.

Sekoleyte_9-1658560779511.png

 

1 best response

Accepted Solutions
best response confirmed by DeFacto (Copper Contributor)
Solution

@DeFacto 

After i filter the range according to the comparison condition, i counted how many cells we have. Then i divided it by rows number.

Sekoleyte_9-1658560779511.png

 

View solution in original post