O5=LARGE(($D$2:$L$2=O$2)*($D$3:$L$3=O$3)*TRANSPOSE(ROW(INDIRECT("1:9"))),1)
O6=SUMPRODUCT(IF(OFFSET($D$4,0,O5-1,40)="x",1,0)*($B$4:$B$43=O$4))
execl download:
https://drive.google.com/file/d/1aB_NyIHybG3mdACJmU4MV4roerVER6DF/view?usp=sharing
係咪想咁整?
O5=LARGE(($D$2:$L$2=O$2)*($D$3:$L$3=O$3)*TRANSPOSE(ROW(INDIRECT("1:9"))),1)
O6=SUMPRODUCT(IF(OFFSET($D$4,0,O5-1,40)="x",1,0)*($B$4:$B$43=O$4))