- ©«¤l
- 2833
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2889
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-12
|
¥»©«³Ì«á¥Ñ ã´£³¡ªL ©ó 2019-11-30 12:53 ½s¿è
FL4:
=SUMPRODUCT(OFFSET($EX4,,SUM(COLUMN(A1)*3-3),,2)*$G4^{1,0})*(ES4<0)
©Î
=SUM(INDEX($EX4:$FH4,N(IF(1,COLUMN(A1)*3-{2,1})))*$G4^{1,0})*(ES4<0)
©Î
=MMULT(OFFSET($EX4,,SUM(COLUMN(A1)*3-3),,2),$G4^{1;0})*(ES4<0) |
|