ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¦p¦ó¥H®É¶¡¬°§Ç¸¹¦Û°Êµ²ºâ¶R½æª÷ÃB

¨S¦³«Ü§¹¾ãªºªí¥Ü¡A©êºp¡C§Ú·Qªí¹Fªº¬O¥H®É¶¡¬yÂ઺¹Lµ{¤¤¡F¥ý¶R¥ý½æ¡A«á¶R«á½æ¡C¦p¤U¡G08:46:51¶R¶i1¦¨¥æ»ù ...
huan µoªí©ó 2010-10-9 10:21

ªþÀɦn¹³¤Ö¤F¤@Äæ ªÑ²¼¦WºÙ ©Î ´Á³f¦WºÙ?
§A¬O­n¦C¥X ¦U¼i¬ù®É¶¡¸Ìªº(ªÑ²¼ ©Î ´Á³f)¶R½æ¬Û©è«áªºª÷ÃB¶Ü? ¬O½Ð¦AªþÀɬݬÝ

TOP

¦^´_ 11# huan
§ä¤@¦UªÅ¥Õªº¦ì¸m¼g¤U=SUMPRODUCT((A2:A65535="¶R¶i")*(B2:B65535)*(C2:C65535))-SUMPRODUCT((A2:A65536="½æ¥X")*(B2:B65536)*(C2:C65536))

TOP

¦^´_ 14# huan
ÀH­Ó¤H³ß¦n §A¤S¨Sªþ¤W§A­nªº½d¨Ò ¤£ª¾¦p¦ó¸Ñµª°Ú!

TOP

¦^´_ 16# huan
=SUMPRODUCT(($A$2:$A2="½æ¥X")*($B$2:$B2)*($C$2:$C2))-SUMPRODUCT(($A$2:A2="¶R¶i")*($B$2:B2)*($C$2:$C2))
¤½¦¡¼g¦bE2 µM«á¤U©Ô

TOP

¦^´_ 19# huan
¨S¦³¥X²{¨Cµ§µ²ºâª÷ÃB    ½Ð°Ý¨Cµ§¬O¤°»ò·N«ä?

TOP

¦^´_ 21# huan
½ÐÁÙ­n¥[µù»¡©ú,¯u¬OªÑ¥«ªº¥~¦æ¤H,¬Ý¤£À´­n¦p¦óÀ°§A´N¦p¤U¦Cºô§}.
http://forum.twbts.com/viewthread.php?tid=1457&rpid=7365&ordertype=0&page=2#pid7365

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD