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

°}¦C¦p¦ó¨Ï¥Î

°}¦C¦p¦ó¨Ï¥Î

½Ð°Ý¦³¤j¤j¯à¸ÑÄÀ°}¦C¦p¦ó¨Ï¥Î¶Ü
§Ú¬Ý¤F«e½ú¨Ï¥Îªº¤½¦¡¡A¦ý¬O¬Ý¤£À´¦p¦ó¥Îªº¡A¦³¤j¤j¯àÀ°¦£Á¿¸Ñ¶Ü

­n¦p¦óÀù¯àÅý»È¦æ±bªº335¦b¤½¥q±b¤W¦³¥X²{¨â¦¸©O

¦pªG¤½¦¡¼g³o¼Ë¬O¤°»ò·N«ä? {D8=$B$8:$B$12} ¬Oªí¥ÜD8¦pªGµ¥©óB8¨ìB12°Ï¶¡¥ô¤@­Ó­È¬Û¦Pªº¸Ü¬°TURE¶Ü?

ÁÂÁÂ

excel°}¦C¨Ï¥Î¨D±Ï.rar (6.36 KB)

=SUMPRODUCT((A$2:A$50-C2=0)*(B$2:B$50=D2))
{=SUM((A$2:A$50-C2=0)*(B$2:B$50=D2))

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2016-8-4 14:47 ½s¿è

¦^´_ 1# popomilk
¸Ñ1¡B¸ê®Æ½d³òA2:D5 (µLÃö¤é´Á)
Àx¦s®æE2¿é¤J
=COUNTIF($B$2:$B$5,D2)
¦V¤U½Æ»s

¸Ñ2¡B»s§@°ÊºA½d³ò (µLÃö¤é´Á)
©w¸q¦WºÙ¡u¤½¥q±b¡v
°Ñ·Ó¨ì¿é¤J=OFFSET(Sheet2!$B$2,,,COUNTA(Sheet2!$B:$B)-1)
Àx¦s®æE2¿é¤J
=COUNTIF(¤½¥q±b,D2)
¦V¤U½Æ»s

½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# hcm19522


   {=SUM((A$2:A$50-C2=0)*(B$2:B$50=D2))
¤£¦n·N«ä½Ð°Ý³o¬O¤°»ò·N«ä
A2¨ìA50´îC2¬°0ªº¦³¨â­Ó
B2¨ìB50µ¥©óD2ªº¤]¦³¨â­Ó
³o¼Ë¬Û­¼¤£¬Oµ¥©ó4¶Ü?

TOP

¦^´_ 3# p212


ÁÂÁ§A
countif²³æ¦n¥Î

TOP

¦^´_  hcm19522


   {=SUM((A$2:A$50-C2=0)*(B$2:B$50=D2))
¤£¦n·N«ä½Ð°Ý³o¬O¤°»ò·N«ä
A2¨ìA50´îC2¬° ...
popomilk µoªí©ó 2016-8-4 15:45

http://blog.xuite.net/hcm19522/twblog

TOP

¦^´_ 4# popomilk
{±ø¥ó¤£¦¨¥ß,±ø¥ó¦¨¥ß,±ø¥ó¤£¦¨¥ß,±ø¥ó¦¨¥ß}*{±ø¥ó¤£¦¨¥ß,±ø¥ó¦¨¥ß,±ø¥ó¤£¦¨¥ß,±ø¥ó¦¨¥ß}-->±ø¥ó¦¨¥ß¬°1,±ø¥ó¤£¦¨¥ß¬°0-->{0,1,0,1}*{0,1,0,1}-->{0,1,0,1}-->¥[Á`=2
{±ø¥ó¤£¦¨¥ß,±ø¥ó¤£¦¨¥ß,±ø¥ó¤£¦¨¥ß,±ø¥ó¦¨¥ß}*{±ø¥ó¤£¦¨¥ß,±ø¥ó¦¨¥ß,±ø¥ó¤£¦¨¥ß,±ø¥ó¦¨¥ß}-->±ø¥ó¦¨¥ß¬°1,±ø¥ó¤£¦¨¥ß¬°0-->{0,0,0,1}*{0,1,0,1}-->{0,0,0,1}-->¥[Á`=1 (0*¥ô¦ó¼Æ¬°0)

TOP

¦^´_ 1# popomilk

¦P¤@¤Ñ(¤é´Á)¸Ì¡A»È¦æ±b¸¹¦b¤½¥q±b¸¹¸Ì¥X²{¦¸¼Æ¡C
E2 =COUNTIFS(A$2:A$5,C2,B$2:B$5,D2)
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD