- ©«¤l
- 6
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- w7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-4-20
- ³Ì«áµn¿ý
- 2019-3-10
|
¦U¦ì«e½ú...
§Ú¦³¥÷¸ê®Æ»Ýn°µ±ø¥ó§PÂ_,sheet4¤º¨C¦¸ªº¸ê®Æ³£¬O¸Uµ§°_¸õ
¦ý²{¦b¹J¨ìªº°ÝÃD,SUMPRODUCTªº¤½¦¡®M¥Î¦b±Nªñ4000ÓÀx¦s®æ,
©Ò¥H¨C·í¸ê®Æ¦³©ÒÅÜ°Ê,´N·|«·sŪ¨ú¤@¦¸®É¶¡«D±`ªº¤[...
¬O§_¦³¤èªk¯à¨Ï¥H¤Wªº§PÂ_¥u°µ¤@¦¸Åª¨ú??
©Î¬O±N =SUMPRODUCT((Sheet4!$B:$B=$C$2)*(Sheet4!$C:$C=F2))ÂàÅܬ°VBA??
ªþ¤WÀɮ׽ШD¦U¦ì«e½ú«üÂI. (ÀÉ®×¥u¦³³¡¤À®æ¦¡) |
-
-
test1.zip
(11.46 KB)
³¡¤À®æ¦¡
|