Forum Discussion
Excel Formula
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))
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.
Hi Sergei,
Not really...
Each line should correspond to a budget number, however, some budgets have more than one item, forcing me to use more than one line for the same budget, the information I need is how many budgets per unit I received, and for that I I should only consider the line that contains item number 10.
Thank you
So the row #3 and the answer is 1?
yes, the formula should ignore line 4 and 5, in this case