Forum Discussion
Solved
Excel Formula
Hello
I need a formula that tells how many times a given value exists in column "B" as long as the corresponding row value in column "A" is greater than 10.
Thank you,
Thus A is equal to 10, not more than 10. When
=COUNTIFS(A1:A10,10,B1:B10,"RJ")
or
=SUMPRODUCT((B2:B10="RJ")*(A2:A10=10))
yes, the formula should ignore line 4 and 5, in this case
Thus A is equal to 10, not more than 10. When
=COUNTIFS(A1:A10,10,B1:B10,"RJ")
or
=SUMPRODUCT((B2:B10="RJ")*(A2:A10=10))
Hello Sergei,
It worked, thank you very much for the help.