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

[µo°Ý] ­pºâÃþ§O±ø¥ó¥[Á`

[µo°Ý] ­pºâÃþ§O±ø¥ó¥[Á`

¦U¦ì¤j­ô¡A¤p§Ì·Q±qªþ¥ó ªí®æ¤¤ «ö·Ó¦³"Á`¤½¥q"¦r¼Ë­pºâ¥X©Ò»Ýª÷ÃB¡AÀµ½Ð¤j¤j«üÂI¡C Book2.rar (1.8 KB)

Book2.rar (1.8 KB)

¥»©«³Ì«á¥Ñ p212 ©ó 2013-6-5 11:12 ½s¿è

¦^´_ 1# home1913
1.¥X³f¶q=SUMIF(B2:C7,"Á`¤½¥q",C2:C7)
2.¦A­¼¤W³f¶q³æ»ù§Y¥i
½Ð°Ñ¦Ò¡I

TOP

F¦C¬°½c¤J¼Æ¡A¬G³f¸¹­n¹ïÀ³¨ì¬Û¦Pªº½c¤J¼Æ°µ¬Û°£¤~¦³¿ìªk­¼¤Wª÷ÃB¡A¥Ø«e¥d¦b³oÃä
·PÁ±z~

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-6-5 15:06 ½s¿è

¦^´_ 3# home1913
1¡B½Ð©óD2Àx¦s®æ¿é¤J
=IF((C2/VLOOKUP(A2,$F$2:$G$8,2,0))<1,C2*2,(C2/VLOOKUP(A2,$F$2:$G$8,2,0))*10)
   Äò©¹¤U½Æ»s¤½¦¡¡C
2¡B©ó±z©Ò­n§e²{µ²ªGªºÀx¦s®æ¿é¤J
=SUMIF(B2:D7,"Á`¤½¥q",D2:D7)
   ½Ð°Ñ¦Ò¡I

TOP

  1. =SUMPRODUCT((B2:B7="Á`¤½¥q")*INT(C2:C7/VLOOKUP(A2:A7,E2:F8,2,))*10) + SUMPRODUCT((B2:B7="Á`¤½¥q")*MOD(C2:C7,VLOOKUP(A2:A7,E2:F8,2,))*2)
½Æ»s¥N½X
«e¬q¬°¾ã¼Æ½c¶O¥Î
«á¬q¬°¹s´²¼Æ¶O¥Î
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

  1. =SUMPRODUCT((B2:B7="Á`¤½¥q")*INT(C2:C7/VLOOKUP(A2:A7,E2:F8,2,))*10) + SUMPRODUCT((B2:B7="Á`¤½¥q")*MOD(C2:C7,VLOOKUP(A2:A7,E2:F8,2,))*2)
½Æ»s¥N½X
«e¬q¬°¾ã¼Æ½c¶O¥Î
«á¬q¬°¹s´²¼Æ¶O¥Î
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 1# home1913

"Á`¤½¥q¥X³fª÷ÃB¬°¾ã½c10¤¸¤£º¡½c 1 PCS 2¤¸¡FA1&B1¤£¦C¤J­pºâ"
¦³ÂI¸Þ²§¡K¤ñ¤è»¡³f¸¹"120351755"½c¤J¼Æ¬°70
©Ò¥H³f¶q70ªº¸Ü¬O10¤¸¡A¦ý¬O³f¶q69ªº¸Ü´NÅܦ¨138¤¸¡H¡I

TOP

¦^´_ 7# Bodhidharma

¬Oªº~¨S¿ù!

TOP

¦^´_ 6# ML089

½Ð°Ý SUMPRODUCT¦³¿ìªk¼g¦b¤@°_¶Ü?

TOP

¦^´_ 9# home1913

¥Îsum+if? (°}¦C¤½¦¡)
  1. =SUM(IF(B2:B7="Á`¤½¥q",INT(C2:C7/VLOOKUP(A2:A7,E2:F8,2,))*10+MOD(C2:C7,VLOOKUP(A2:A7,E2:F8,2,))*2))
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD