Forum Discussion
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 ...
Hi,
Try this formula in cell E6:
=SUMPRODUCT((E8:J15="x")*(D8:D15="S"))
Hope this helps
Regards,
IlirU.
