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

¦p¦ó²Î­p¤H¼Æ¦~ÄÖ?

¦p¦ó²Î­p¤H¼Æ¦~ÄÖ?

¦p¦ó²Î­p¤H¼Æ¦~ÄÖ?
¤u§@ªí1
111111111111.jpg
2013-1-16 00:59

¤u§@ªí2
11111111111.jpg
2013-1-16 00:59


¤u§@ªí¤@­n¦p¦ó²Î­p¤H¼Æ¨ì¤u§@ªí¤G
PS.¸ê®Æ·|¤@ª½¼W¥[

³Â·Ð«e½úÀ°¦£

test.rar (34.8 KB)

excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

¦^´_ 1# kkooo15
½Ð°Ñ¦Ò
¤u§@ªí¤G¤§A3Àx¦s®æ¼g¤J =SUMIF(¤u§@ªí1!F:F,¤u§@ªí2!B3,¤u§@ªí1!E:E)¡A¤§«á¦V¤U½Æ»s¤½¦¡¡C
¤u§@ªí¤G¤§C3Àx¦s®æ¼g¤J =SUMIF(¤u§@ªí1!H:H,¤u§@ªí2!D3,¤u§@ªí1!G:G)¡A¤§«á¦V¤U½Æ»s¤½¦¡¡C

test_°Ñ¦Ò.zip (36.35 KB)

TOP

ÁÂÁ«e½ú¨º»ò§Ö´N¦^´_
À°¤F§Ú¤@­Ó¤j¦£!!

§Ú¤Wºô¬d¤F¤@¤USUMIF¨ç¼Æ¤u¯à!!
¤@¡B    ¥\¯à­pºâ¸ê®Æ½d³ò¤¤²Å¦X±ø¥ó¤§¸ê®Æ¡A»P¨ä©Ò°t¹ï¤§¥[Á`¸ê®ÆªºÁ`©M
¤G¡B   »yªkSUMIF(¸ê®Æ½d³ò¡A·Ç«h±ø¥ó¡A¹ê»Ú¥[Á`¸ê®Æªº½d³ò)
¡°    ·Ç«h±ø¥óªº«¬¦¡¥i¥H¬O¼Æ¦r¡B¤å¦r©Îªí¥Ü¦¡
¤T¡B          ½d¨Ò
-----------------------------------------------------------------------------
­pºâ¤£¤Î®æ¬ì¥Ø¼Æ¡B¾Ç¤À¼Æ(¡u¨ç¼Æ.xls¡vªº¡uSUMIF(1)¡v¤u§@ªí)
l      ­pºâ¤£¤Î®æ¬ì¥Ø¼Æ¡G H4ªº¤½¦¡ ¡÷ =COUNTIF(C4¡GG4,"<60")®æ¦¡ ¡÷ 0 "¬ì"
l      ­pºâ¤£¤Î®æ¾Ç¤À¼Æ I4ªº¤½¦¡=SUMIF(C4¡GG4,"<60"$C$2)¡G$C$2¡G$G$2)®æ¦¡ ¡÷ 0 "¾Ç¤À"
excel¾Ç²ß¤¤!¿v¥X¹Ú·Q
https://www.youtube.com/channel/UCPAiRNsHX3k_omp0YDgfDiA

TOP

A3 ¤½¦¡ ¦A½Æ»s C3 ¦A¤U©Ô
=SUMIF(¤u§@ªí1!F:F,B3,¤u§@ªí1!E$1)
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD