Excel Formula

[Kleber Seguro - curlie]

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,

[#2]

Hi Kleber,

As variant that could be

=SUMPRODUCT((B:B=<your value>)*(A:A>10))

[#3]

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

[#4]

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

[#5]

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

[#6]

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.

[#7]

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

[#8]

So the row #3 and the answer is 1?

[#9]

yes, the formula should ignore line 4 and 5, in this case

[#10 · Accepted solution]

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))

[#11]

Hello Sergei,

It worked, thank you very much for the help.