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))
Hi Kleber,
Let say that the value you want to check is "v", and it's located in cell C2, so you can use this formula:
=COUNTIFS(A1:A13,">10",B1:B13,C2)
Please find it also in the attached file!
Regards
Sorry, I did not explain it correctly.
I need a formula that tells me how many times the acronym RJ has been posted in column "B" (LOCATION), as long as the value of the same row in column "A" (ITEM) is greater than 10.
Attached, send the worksheet as an example.
Thank you