IFCOUNT fonction

[behpaja]

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.

[#2 · Accepted solution]

Hi,

Try this formula in cell E6:

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

Hope this helps

Regards,

IlirU.

[#3]

perfect! it working well
thanks a lot!

60 minute lost and 3 menute to resolve with you! :)

[#4]

I'm glad I helped you!
Enjoy it...