Forum Discussion
How do create a matrix formula to calculate in all range (B:F) with this rare condition.
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.
Im trying to find the way to send you.
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.
Thanks, only now I understood that there is an internal structure by themes, thanks for suggesting, didn't know it, I just published and it came out there. But any way, help me with this please, I have been looking for a solution in several excel groups for several months and nobody has given a solution closer to yours. This formula is perfect, only remains to lock the range.
=SOMARPRODUTO(CONT.SE(DESLOC(C17:G17;LIN(17:84)-1;0);$I$5)*CONT.SE(DESLOC(C18:G18;LIN(17:84)-1;0);J17))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.
Sorry, im cracy here trying to understand how the sites work, but is complicated to find the rights answers to do it. I dont know if Im in the comunity or not, or where am i inside the site, let me study the site to doing that correctly .