Jul 22 2022 11:05 PM - edited Jul 22 2022 11:06 PM
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.
Jul 22 2022 11:45 PM - edited Jul 23 2022 12:19 AM
SolutionAfter i filter the range according to the comparison condition, i counted how many cells we have. Then i divided it by rows number.
Jul 22 2022 11:45 PM - edited Jul 23 2022 12:19 AM
SolutionAfter i filter the range according to the comparison condition, i counted how many cells we have. Then i divided it by rows number.