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

[µo°Ý] ¿z¿ï«á¥[Á`

[µo°Ý] ¿z¿ï«á¥[Á`

½Ð°Ý¦p¦ó¿z¿ï¥X¡A§÷½è=A36¡A³W®æ¬°RH¬°¶}ÀYªºÁ`­«¡A¨Ã§â²Å¦X§÷½è©M³W®æªºÁ`­«¥[Á`©O???




¿z¿ï«á¥[Á`.rar (5.14 KB)

J1¤½¦¡¡G=SUBTOTAL(9,H:H)
¦Û°Ê¿z¿ï¡A§÷½è¿ïA36,³W®æ¿ï¦Û­q¡A¶}ÀY¥HRH

TOP

°£¤F¦Û°Ê¿z¿ïªº¤èªk¥~ÁÙ¦³¨ä¥¦ªº¶Ü???

TOP

§Aªº°ÝÃD¬O"¿z¿ï«á¥[Á`", ¤£·Q­n¦Û°Ê¿z¿ïÁÙ¦³¶i¶¥¿z¿ï§r¡I

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-11-22 21:53 ½s¿è

¨º¬O§_¯à¥Îsumifªº¤è¦¡°µ¥X¨Ó©O???

¦]¬°§Ú¥u·|¥Î{=SUM(IF($E$2:$E$23=E30,IF($D$2:$D$23=F30,$H$2:$H$23,0),0))}

§â²Å¦XA36 ©M RH300X300X10X15X7754 ³o2­Ó­Èºâ¥X¨Ó

¬O§_¯à§â²Å¦XA36©M¥HRH¶}ÀYªºÁ`­È¥HSUMIFªº¤è¦¡ºâ¥X¨Ó©O??

TOP

¥»©«³Ì«á¥Ñ oobird ©ó 2010-11-22 21:53 ½s¿è

¥Î¤½¦¡¥i¥Îsumproduct©Îlookup¹Bºâ¡AÂù±ø¥ó¤£¯à¥Îsumif.
§A¥Îªº¬Osum°}¦C¡A¤]¬O¥i¥Hªº¡A¦Û¤v°µ§a¡I
¤£¹L¤£«Øij¡A¬Ý³o©«¡Ghttp://forum.twbts.com/thread-1962-1-1.html

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-11-22 21:59 ½s¿è

2007ª©¦³SUMIFS
=SUMIFS(H:H,D:D,"RH*",E:E,"=A36")
¨ä¹ê¥Î¦Û°Ê¿z¿ï´N¦¨°Õ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

sumif()¥Î¦bÂù±ø¥ó¤W¥H¤W,¥i¥H¥[¤@»²§UÄæ
»²§UxÄæ=a1&b1&c1&d1
=sumif(x:x,...,...)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

gong¤j¤j,Âù±ø¥ó¥[»²§UxÄæ,¥i§_¼W¥[»¡©ú,¤£¬O«Ü¤F¸Ñ·N«ä

TOP

¦^´_ 9# aa7551


    ¤£«ü©w¥Î¬Æ»ò¨ç¼Æ¸Õ¸Õ
=SUMPRODUCT((LEFT($D$2:$D$23,2)="RH")*($E$2:$E$23="A36"),$H$2:$H$23)

SUMIF¥[»²§UÄæ
¦p:J2=LEFT(D2,2)&E2¦V¤U½Æ»s
=SUMIF(J2:J23,"RHA36",H2:H23)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD