Simplifying a big formula

Hi, try this.

=SUMPRODUCT((_FC>=CP1)*(_FC<=CP2)*COUNTIF(BM4,CHOOSE({1,2,3,4,5,6,7},_1,_2,_3,_4,_5,_6,_7)))

If you want to count BM4 only one time for a row, try this

=SUMPRODUCT((_FC>=CP1)*(_FC<=CP2)*(MMULT(COUNTIF(BM4,CHOOSE({1,2,3,4,5,6,7},_1,_2,_3,_4,_5,_6,_7)),{1;2;3;4;5;6;7})>0))