- ©«¤l
- 163
- ¥DÃD
- 45
- ºëµØ
- 0
- ¿n¤À
- 246
- ÂI¦W
- 27
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- ie
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-7-8
- ³Ì«áµn¿ý
- 2024-9-14
|
sumproducts °ÝÃD
¥»©«³Ì«á¥Ñ mdr0465 ©ó 2017-11-14 20:03 ½s¿è
¦U¦ì:
¦b¬¡¶ªí "SUMMARY"
"B43"®æ¤½¦¡¬O: =SUMPRODUCT(('NOV''17'!$C$2:$C$181="BBJ")*('NOV''17'!$L$2:$L$181="S")*('NOV''17'!$G$2:$G$181))
"B44"®æ¤½¦¡¬O: =SUMPRODUCT(('NOV''17'!$C$2:$C$181="BBJ")*('NOV''17'!$L$2:$L$181="S")*('NOV''17'!$J$2:$J$181))
¬°¤°»ò¨â±ø¤½¦¡¥u¬Opºâ¤£¦PªºÄæ¦ì,¦ýµª®×·|¦³¿ù»~©O??
½Ð¦U¦ì½ç±Ð,ÁÂÁ |
|