Forum Discussion
Solved
How do create a matrix formula to calculate in all range (B:F) with this rare condition.
Bom dia família, Preciso criar uma fórmula matricial para calcular quantas vezes essa coincidência aparece em todo o intervalo B:F , de acordo com essas condições ( A) na primeira linha ), ( M) ...
I recommend to post your question in the Microsoft Community for Excel. There are many more users than in the Microsoft Community for Data where your post is right now.
When you start a new discussion you can drag and drop or browse file as shown in the attached file.
In the attached file there are two sheets. In sheet "Tabelle2" is your formula.
=SOMARPRODUTO(CONT.SE(DESLOC(C17:G17;LIN(17:84)-1;0);$I$5)*CONT.SE(DESLOC(C18:G18;LIN(17:84)-1;0);J17))
Is this what you want to do?
I already checked the formula u send, and i dont have words to thank you for this, is perfect. You cant imagine how important it is for me. From this moment I will always be in debt with you.
God bless you.
God bless you.