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

[µo°Ý] ¤å¦r¤£¦P EXCEL·í§@¤@¼Ë= =

[µo°Ý] ¤å¦r¤£¦P EXCEL·í§@¤@¼Ë= =

¥»©«³Ì«á¥Ñ toxin ©ó 2012-7-5 13:43 ½s¿è

½Ð°Ý¦U¦ì¤j®v
²{¦³¨â¦r¦ê
¦r¦êA¡G£p110*150L
¦r¦êB¡G£p110*50L
·j´M®ÉA·|·í§@¸òB¤@¼Ë
B¤£·|¸òA¬Û¦P
¤]´N¬O»¡Application.SumIf
ªº®É­Ô²Ö¥[¼Æ¶q
A¦³10­Ó
B¦³20­Ó
·|Åܦ¨
A¦³10­Ó
BÅܦ¨10+20¦@30­Ó
¦pªþ¥óªí1¤¤463¦C¸ò465¦C
0705.rar (57.63 KB)

¥»©«³Ì«á¥Ñ kimbal ©ó 2012-7-5 21:08 ½s¿è

¥ý§â"*" Âର"~*"
¨Ò¦p
Application.SumIf(Sheets("¶i®w").Range("C:I"), Range("A" & IA), Sheets("¶i®w").Range("I:I"))
Âର
  1. Application.SumIf(Sheets("¶i®w").Range("C:I"), replace(Range("A" & IA).value,"*","~*"), Sheets("¶i®w").Range("I:I"))
½Æ»s¥N½X
*¦b·j´M®É¬O¦Ê·f¦r²Åªº·N«ä,   ­n§ä*ªº¸Ü­n¦b *«e¥[¤W~¸¹
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

ÁöµM¨S¿ìªk¤U¸üÀÉ®×,¦ý¤j·§²q±o¥X°ÝÃD¥X¦b¨º¸Ì

* ¬O¸U¥Î¦r¤¸,±ý¨ú®ø¨ä¸U¥Î¦r¤¸¯S©Ê¥²»Ý¦b«e­±¥[~²Å¸¹,¨Ò¦p ~*

¥Î¤½¦¡ªº¸Ü¸Õ¸Õ±NA1°Ñ·Ó§ï¬°SUBSTITUTE(A1,"*","~*")
¨Ò¦p
=SUMIF(A:A,SUBSTITUTE(A1,"*","~*"),B:B)

¥Î¥¨¶°ªº¸Ü¸Õ¸Õ±N[A1]°Ñ·Ó§ï¬°REPLACE(A1,"*","~*")
¨Ò¦p
= WorksheetFunction.SumIf(Range("A:A"), Replace([A1], "*", "~*"), Range("B:B"))
My Blog
http://blog.xuite.net/a8350070

TOP

¥»©«³Ì«á¥Ñ toxin ©ó 2012-7-6 08:08 ½s¿è

¦^´_ 2# kimbal
¦^´_ 3# a8350070

­ì¥»¤]¦³·Q¹L¥i¯à¬O*ªºÃö«Y
¦ý¬O....
¦pªG¬O³o¼Ë
Á`¦@4­Ó¬ÛÃö¦r¦êÀ³¸Ó¤]·|¦³·j´M¿ù»~ªº±¡ªp
¦r¦ê¤À§O¬°
£p110*150L
£p110*200L
£p110*50L
£p110*100L
¦ý¬O¥u¦³²Ä¤T­Ó
·|²Ö¥[²Ä¤@­Ó¸ò²Ä¤T­Ó¦r¦êªº¼Æ¶q

TOP

¦^´_ 2# kimbal

§Ñ°O»¡
§ï¦¨³o¼Ë´N¥i¥H¤F
·PÁ¤j®v

TOP

¦^´_  kimbal
¦^´_  a8350070

Á`¦@4­Ó¬ÛÃö¦r¦êÀ³¸Ó¤]·|¦³·j´M¿ù»~ªº±¡ªp
¦r¦ê¤À§O¬°
£p110*150L
£p110*200L
£p110*50L
£p110*100L
¦ý¬O¥u¦³²Ä¤T­Ó
·|²Ö¥[²Ä¤@­Ó¸ò²Ä¤T­Ó¦r¦êªº¼Æ¶q
toxin µoªí©ó 2012-7-6 08:07


¦pªG¯à©úÁA*ªº¸U¥Î¦r¤¸¯S©Êªº¸Ü´N¤£Ãø²z¸Ñ¬°¦ó¦p¦¹¤F
£p110*150L    ¯à²Å¦X £p110*50L ªº³W«h ,¦] *1 ¯à¥H * §@²[»\
¦ý¬O £p110*50L  ¤£¯à²Å¦X £p110*150Lªº³W«h , ¦]¬°¤Ö¤F¤@­Ó 1 ¦r¤¸
My Blog
http://blog.xuite.net/a8350070

TOP

¦^´_ 6# a8350070
¤j­P¤W¤F¸Ñ¤F
·PÁÂ"a8350070"¤j¤jªº¦^ÂÐ

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD