Feb 14 2018
07:22 AM
- last edited on
Jul 25 2018
11:03 AM
by
TechCommunityAP
Feb 14 2018
07:22 AM
- last edited on
Jul 25 2018
11:03 AM
by
TechCommunityAP
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,
Feb 14 2018 07:27 AM
Hi Kleber,
As variant that could be
=SUMPRODUCT((B:B=<your value>)*(A:A>10))
Feb 14 2018 07:33 AM
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
Feb 14 2018 07:54 AM
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
Feb 14 2018 07:56 AM
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
Feb 14 2018 09:03 AM
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.
Feb 14 2018 09:33 AM
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
Feb 14 2018 12:24 PM
SolutionThus 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))
Feb 14 2018 12:24 PM
SolutionThus 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))