Forum Discussion

Kleber Seguro - curlie's avatar
Kleber Seguro - curlie
Copper Contributor
Feb 14, 2018

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,

  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 14, 2018

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

     

    • Kleber Seguro - curlie's avatar
      Kleber Seguro - curlie
      Copper 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

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP

        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 Amairah's avatar
    Haytham Amairah
    Silver 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 - curlie's avatar
      Kleber Seguro - curlie
      Copper 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

       

Resources