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.
=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.
Thank so much my hero, Im going to test the formula and give u a feedback.