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

¨ç¼Æ¦p¦ó¿z¿ï¨âºØÃþ«¬¸ê®Æ

¨ç¼Æ¦p¦ó¿z¿ï¨âºØÃþ«¬¸ê®Æ

·Q½Ð°Ý¤@¤U¤j¤j³á
¦pªG§Ú·Q­n§Q¥Î¨ç¼Æ
±N¦hµ§­«Âиê®Æ¸Ì­±ªº¤u®É²Î­p¥X¨Ó(¦p¤U¹Ï)
¿Ã¹õºI¹Ï00165.jpg
2013-4-12 11:34


¦pªG¥u¬O³æ¯Â¤O¥ÎSUMªº¸Ü
´N¤£¤ÀÃþ«¬ªº²Î­p¤u®É
¨º¦pªG¥u·Q­n¬ü³N¨ó§Uªº¤u®É²Î­p
­n¦p¦ó§Q¥Î±ø¥ó?

§Æ±æ°ª¤H«üÂI¡A¤£³Ó·P¿E>\<
Jared

¦^´_ 1# Jared
¦bL7Àx¦s®æ¿é¤J=SUMIF(H:I,K7,I:I)¡A¦V¤U½Æ»s¡A³o¼Ë¥i¥H¶Ü¡H

TOP

¦^´_ 2# p212


·PÁ¤j¤j~ ¯uªº¦n¤è«K(^¤f^)
¦ý¬O¦pªG¦h¤F­n¤À¤ë¥÷¶i¦æ²Î­pªº±¡ªp
¦pªG¬O³æ¤@²Î­p¬Û¦PÃþ«¬ªº¤u§@¡A§Ú¬O¼g¦¨
  1. =COUNTIF(¢Ö¢´:H18,"A")
½Æ»s¥N½X
¥[¤W ¤j¤j´£¨Ñªº¨âºØ¸ê®Æ°µ²Î­p¤u®Éªº¹Bºâ
=SUMIF(H:I,H23,I:I)

²{¦bªÌ¨âºØ·j´M¤è¦¡¦pªG¦h¤F¤ë¥÷±ø¥ó
­n«ç»ò²K¥[¤W¥h©O?
¨ç¼Æ¯à§PÂ_¤é´Á¸òÄݩʶÜ?? (@@)

´±°Ý¤j¤j¡A«D±`·PÁ¡I¡@¡Ö\\¡Õ
Jared

TOP

¦^´_ 3# Jared

©êºp§Ñ¤F¸É¤W·Ó¤ù¸òÀÉ®×
¿Ã¹õºI¹Ï00168.jpg
2013-4-12 15:32

Book1.zip (9.52 KB)
Jared

TOP

¥»©«³Ì«á¥Ñ kimbal ©ó 2013-4-13 00:43 ½s¿è
¦^´_  Jared

©êºp§Ñ¤F¸É¤W·Ó¤ù¸òÀÉ®×
Jared µoªí©ó 2013-4-12 15:32


°µ­Ó¼Ï¯Ãªí¦p¦ó? ¤£¥Î­W´o·Q¤½¦¡, ¦h­Ó±ø¥ó¤]¥i¥H

   
twbts20130413pivot.jpg
2013-4-13 00:29


ÁÙ¬O·Q¥Î¤½¦¡ªº¸Ü,¥i¥H¥ÎSUMPRODUCT©M¥[¨Ç¸É§UÄæ¦ì
twbts20130413sumproduct.jpg
2013-4-13 00:37


¤£·Q¥[DÄ檺¸Ü,¥Î°}¦C¤½¦¡¤]¥i
twbts20130413arrayformula.jpg
2013-4-13 00:41
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

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

TOP

¦^´_ 5# kimbal


   ½Ð°Ý¤@¤U¤j¤j³á
¬°¤°»ò·Ó¤½¦¡¥h¶]ÁÙ¬O¨SªF¦è©O??
¿Ã¹õºI¹Ï00169.jpg
2013-4-15 10:57


¦pªG¤è«Kªº¸Ü
¥i¥Hªþ¤WÀɮ׶Ü?
·P¿E¤£ºÉ!!
Jared

TOP

¦^´_ 5# kimbal


§Ú«á¨Óµo²{­n§âMONTH(C2) ¥t¥~¼g¦b¤@¦æ
¨S¿ìªk¨Ï¥ÎMONTH(C2:C15)=1
´NµLªk§P§O

¨º§Ú§â³o­Ó¤è¬O®M¥Î¦b­pºâ¬Û¦PÃþ§Oªº®É­Ô
¦n¹³¤£¤ÓºÞ¥Î
¤£¾å±o¬O¤°»ò­ì¦]?
Jared

TOP

        ÀR«ä¦Û¦b : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD