Forum Discussion

behpaja's avatar
behpaja
Copper Contributor
Mar 03, 2021
Solved

IFCOUNT fonction

Hello,

I'm using Excel2016,

I'm freezing in a function formula and I need help from the community.

I'm trying to get a count of "X" of all range E8 to E15, the result will be in E6 if only "S" is written in D column the same row of X. (joined piece "Capture"

 

I can't add some new columns into the right of the XLSX document because I have to do a big review otherwise.

 

thanks in advance.

I'm looking forward to hearing from you

Pascal.

  •  

     

    Hi,

     

    Try this formula in cell E6:

     

    =SUMPRODUCT((E8:J15="x")*(D8:D15="S"))

     

     

    Hope this helps

     

    Regards,

     

    IlirU.

3 Replies

  • IlirU's avatar
    IlirU
    Brass Contributor

     

     

    Hi,

     

    Try this formula in cell E6:

     

    =SUMPRODUCT((E8:J15="x")*(D8:D15="S"))

     

     

    Hope this helps

     

    Regards,

     

    IlirU.

    • behpaja's avatar
      behpaja
      Copper Contributor
      perfect! it working well
      thanks a lot!

      60 minute lost and 3 menute to resolve with you! 🙂
      • IlirU's avatar
        IlirU
        Brass Contributor
        I'm glad I helped you!
        Enjoy it...

Resources