Forum Discussion
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,
As variant that could be
=SUMPRODUCT((B:B=<your value>)*(A:A>10))
- Kleber Seguro - curlieCopper Contributor
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
Hi Kleber,
Just in case, that's not necessary to repeat the answer to everyone - we are all reading.
And I'm not sure I understood you correctly - in you sample only two records meet criteria, in rows #4 and #5, correct?
Both formulas return 2 as the number of such rows.
- Haytham AmairahSilver Contributor
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
- Kleber Seguro - curlieCopper Contributor
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