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

[µo°Ý] ¦p¦ó¨î§@³o¼Ëªº²Î­p

[µo°Ý] ¦p¦ó¨î§@³o¼Ëªº²Î­p

¥»©«³Ì«á¥Ñ K_Wing ©ó 2018-4-19 10:06 ½s¿è

·Q°Ý°Ý·í(¤S©Î"¦pªG")AÄæ / CÄæ / EÄæ ¥X²{¬Y­Ó¼Æ­È(°²³]¬O"7")
¦b¹j¾F¥X²{ªº¬Û¦P¼Æ­È²Î­p¥X²{¦h¤Ö¦¸
(¦p¹Ï©Ò°Ý)



¸É¥R¤@¤U
¬O°Ý²Ä¤@­ÓÄæ¥X²{ªº¤£¦P¼Æ­È(0-9)®É
¦¸Äæ¥X²{¬Û¦P¼Æ­Èªº¦¸¼Æ

¥i¥Hªþ¤WÀɮ׶Ü???

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 3# hcm19522
ÁÂÁ¦^ÂÐ

¤£¬O­n¨D¡y¨C¦æ©_¼ÆÄæ»P¼Æ¦r¬Û¦P¥B¹ïÀ³°¸¼ÆÄæ¥ç¬Û¦P¦¸¼Æ¡z
¬O­n¨D¾í¦âÀx¦s®æ¤ºªº¼Æ¦r(0-9¨C­Ó¼Æ¦r)
©Mºñ¦âÀx¦s®æ¤ºªº¼Æ¦r(0-9¨C­Ó¼Æ¦r)
¤@¦P¥X²{ªº¬Û¦P¦¸¼Æ
²³æ¨Ç»¡
°²³]A®æ¬O¬B¦ì¼Æ=7
B®æ¬O­Ó¦ì¼Æ=9
§Y7©M9(79)¦P®É¥X²{¦h¤Ö¦¸
(¹Ï¤¤¨Ò¤l:2¦¸)

TOP

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2018-4-19 15:46): ÀÉ®×À£ÁY«á¤W¶Ç

¥i¥Hªþ¤WÀɮ׶Ü???
­ã´£³¡ªL µoªí©ó 2018-4-19 10:15


§Úªº¯Å§O
À³¸Ó¤£¯à¤W¶ÇÀÉ®×

TOP

¦^´_ 5# K_Wing


À£ÁY¬°rarÀÉ,¦A¤W¶Ç

TOP

=SUMPRODUCT((A$1:E$20&B$1:F$20=H$8&H9)*{1,0,1,0,1})

TOP

=SUMPRODUCT((A$1:E$20&B$1:F$20=H$8&H9)*{1,0,1,0,1})
­ã´£³¡ªL µoªí©ó 2018-4-19 16:21

¬O³o¼Ë¤F
«D±`·PÁÂ

¦^´_  K_Wing


À£ÁY¬°rarÀÉ,¦A¤W¶Ç
­ã´£³¡ªL µoªí©ó 2018-4-19 16:04

¬JµM­ã´£³¡ªL ¥S¤wµª¨ì¤F
§Ú·Q¤£¥Î¦A¤W¶ÇÀ£ÁYÀɤF

TOP

=SUMPRODUCT((A$1:E$20&B$1:F$20=H$8&H9)*{1,0,1,0,1})
­ã´£³¡ªL µoªí©ó 2018-4-19 16:21

·Q¦A½Ð±Ð{1,0,1,0,1}
³o­Ó¥Nªí¬Æ»ò
¬O§_AB,CD,EFªº¦æ¼Æ
­Y¦æ¼Æ¼W¥[¦ÜGH,IJ,KL
¤S«ç¼Ë­×§ï©O?

TOP

¦^´_ 9# K_Wing


=SUMPRODUCT((A$1:E$20&B$1:F$20=H$8&H9)*{1,0,1,0,1})

A$1:E$20&B$1:F$20 §Î¦¨ 5 Ä檺°}¦C, ¦ý¥u§ì[³æ¼ÆÄæ] ¬G*1, [Âù¼ÆÄæ]¤£­p¤J¦Ó*0

­Y¬O7­ÓÄæ¦ì ,«hÅܦ¨{1,0,1,0,1,0,1})----Ãþ±À

§ï¥Î =SUMPRODUCT((A$1:E$20&B$1:F$20=H$8&H9)*MOD(COLUMN(A:E),2))  ¤]¥i¥H

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD