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.
=SUMPRODUCT(COUNTIF(OFFSET(B3:F3,ROW(1:20)-1,0),"A")*COUNTIF(OFFSET(B4:F4,ROW(1:20)-1,0),"M"))
Maybe with this formula.
The formula calculates perfectly in each case separately, just for the second analysis, the range changes and in that case I don't know how to fix it. I'm trying to send you the original excel but the page doesnt allow or I dont know how to attach it here to show you. I think that i didnt explaing my self as well as i should, sorry is my first time. Cell I5(350) will be dynamic and will take all the values of column (I), column (J) will be the same. Each element(Freq) of column (I), will be tested individually with all element of column (J), and will show the result in the adjacent cell (K). It is an study of frequency in 5 different devices. That's why I need the range be the same, also because it will continue to increase during two years.
If you know the way to attach an excel here, i'll send you..