Forum Discussion
behpaja
Mar 03, 2021Copper Contributor
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.