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

[µo°Ý] ½Ð°ÝÃö©ó²Î­p¤£­«½Æ¶µ¥Øªº­Ó¼Æ"«ü©w±ø¥ó"

¦^´_ 33# ML089


    ªO¤j~¤£¦n·N«ä ¹J¨ì­Ó°ÝÃD

rag=©w¸q¦WºÙ
=SUMPRODUCT(1/COUNTIF(rng,rng))

¦pªGrag½d³ò¤º¦³ªÅ¥Õªº¸Ü¥L¤]·|ºâ¬°¤@­Ó¼Æ¶q,½Ð°Ý¦³¿ìªk¸Ñ¨M¶Ü?

¦p¦A3~300¦C¤§¶¡  
10~15¦C¬OªÅ¥Õªº¸Ü~ <<·|·í¬°¤@­Ó¼Æ¶q

TOP

¦^´_ 33# ML089

·PÁª©¤j¨¯­W¸Ñ¨M,­èµo²{¦pªG¼Æ¶q°µ¨ì10¦ì¼Æªº¸Ü,²Ä5¦ì¤¸´N³Q²¾¨ì²Ä6¤F,

§ÚÁÙ¬O¦V¥DºÞ«Øij±N¥N¸¹´«±¼¦n¤F, ·PÁ¼ö¤ßÀ°¦£

TOP

¦^´_ 32# starry1314

¨ú²Ä2½X»P²Ä5½X¤ñ¸û
D3 =SUMPRODUCT(1/COUNTIF(rng,rng)*(MMULT((MID(rng,{2,5},1)=MID(D$2,{1,2},1))*1,{1;1})=2))        
¥k©Ô        
        
J3 =SUM(D3:I3)        
K3 =SUMIF(D2:I2,"?V",D3:I3)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 29# ML089

ª©¥D~¤£¦n·N«ä ¦b´£¿ô¤º¦³¬Ý¨ì©p¦^´_~¦ý¤å³¹¨S¦³¥X²{....¨S¦³¬Ý¨ì¤º®e

TOP

¦^´_ 30# starry1314

¬O§_¬O³o¼Ë¡A¨ú²Ä2½X»P²Ä5½X¤ñ¸û
D3 =SUMPRODUCT(1/COUNTIF(rng,rng)*(MMULT((MID(rng,{2,5},1)=MID(D$2,{1,2},1))*1,{1;1})=2))       
¥k©Ô       
       
J3 =SUM(D3:I3)       
K3 =SUMIF(D2:I2,"?V",D3:I3)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 29# ML089
¤£¦n·N«ä~¤wªþ¤WÀɮרå[»¡©ú,


    «ü©w±ø¥ó ¤£­«½Æ.rar (8.08 KB)

TOP

¦^´_  ML089


    ¤£¦n·N«ä~¹J¨ì­Ó°ÝÃD¡I¡I¡@¦pªG¡@¢³¢Þ¢´¢Ð¢ä¡]§t¦³¢Þ¢Ð¢ä¡^¡@¡@¡@¢³¢Ð¢´¢ä¡]§t¦³¢Ð¢ä ...
starry1314 µoªí©ó 2015-4-28 14:53


½s½X³W«h¤Î¨ú½X³W«h¤£¬OÁ¿±o«Ü²M·¡¡A
­Y¨S¦³¿ìªkÁ¿¤£¬O«Ü²M·¡®É¡A½Ð§@¥Ü½d¨Ò¤ñ¸ûª¾¹D§A­n¦p¦ó¨ú?

½s½X³W«h¥Ø«e¬O«e4½X©T©w¦³¡A²Ä5½X V ¤£¤@©w¦³
¢³¢Þ¢´¢Ð¢ä §A­n¤ñ¸ûªº½X¦³ ¦r¤¸²Ä2¡B4¡B5¦r¡A³o»P¤W¤èªº BV ¡BPV­n¦p¦ó¹ïÀ³? ¦³®É¹ï²Ä2½X¡B¦³®É¹ï²Ä4½X¡A³o¼Ë¬O¬Ý¤£¥X³W«h
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 26# ML089


    ¤£¦n·N«ä~¹J¨ì­Ó°ÝÃD¡I¡I¡@¦pªG¡@¢³¢Þ¢´¢Ð¢ä¡]§t¦³¢Þ¢Ð¢ä¡^¡@¡@¡@¢³¢Ð¢´¢ä¡]§t¦³¢Ð¢ä¡^¡@·|¾É­P­«½Æ­pºâ¡@½Ð°Ý¥i«ü©w³Ì¥kÃä¼Æ¨Ó¬O¢ä¥B¦b²Ä¢±Äæ¦ì¬O¢Ðªº¶Ü


«ü©w±ø¥ó ¤£­«½Æ.rar (7.7 KB)

TOP

¦^´_ 26# ML089


   ¤F¸Ñ¡ã¥Ø«e¬ù¦b¢°¢¯¢¯¢¯¡ã¢°¢´¢¯¢¯¤§¶¡¡I­n¨ì¢²¢¯¢¯¢¯ÁÙ­n¦³ÂI®É¶¡¡ã¦ý¨ì¨º®É¸ê®Æ®wÀ³¸Ó¤w¸g«Ø¸m§¹¦¨¡A´N¨SÃö«Y¤F!·PÁÂÀ°¦£Åo

TOP

¦^´_ 25# starry1314

COUNTIF(Rng,Rng)

Rng ¸ê®Æ½d³ò¶W¹L3000µ§´N·|«ÜºC
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ­×¦æ­nô½t­×¤ß¡AÂǨƽm¤ß¡AÀH³B¾i¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD