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

[µo°Ý] Excel Àx¦s®æ§PÂ_®É¶¡

[µo°Ý] Excel Àx¦s®æ§PÂ_®É¶¡

½Ð°Ý¦U¦ì¥ý¶i¡G

¤p§Ì·Q­n§ì¨úÀx¦s®æ¸Ì­±ªº­È
¦³¤@­Ó¬OA :¾ú¥v¸ê®ÆªºExcel ¤@­Ó¬OB:¤½¦¡ªºExcel

¾ú¥v¸ê®Æ®æ¦¡



¦bÀx¦s®æ¸Ì­±¥i¥H¼g®É¶¡§PÂ_¶Ü?
¤ñ¦p»¡ ­n§ì 10:45:00  ªº S¬Û¹qÀ£­È
§â³o­Ó¤½¦¡¼g¦bB ªºExcel Àx¦s®æ °µ³sµ²

½Ð±Ð³o¼Ë­n«ç»ò¼g§PÂ_¦¡©O?  ÁÂÁ¡C
§A¦n



¬O§_³o¼Ë? ¤§«e¦b³o¸Ì¾Çªº.

TOP

¦^´_ 2# ricky8751

¤j¤j§A¦n¡A·PÁ§Aªº¦^µª¡C

00:00
07:30
22:30

¦]¬°¾ú¥v¸ê®Æ¡A¦s°_¨Óªº®æ¦¡¤£ª¾¹D·|¦b­þ¤@®æ!
©Ò¥H¤~·Q¨ì­n¥Î®É¶¡°µ§PÂ_¡A¦A¥h§ì¨ú·Q­nªºÄæ¦ì
¤j¤j§A³o­Ó¤èªk¡A¥i¥H³o¼Ë°µ¶Ü?
ÁÂÁ¡C
§A¦n

TOP

¦^´_ 3# macacajau


    À³¸Ó¥i¥Hªº, ¤£¯à¤~­n¦]¬°À³®æ¦¡¬O«ç¼Ë«O¦s¦A¨M©w¦p¦ó§ï¼g¨ç¼Æ.

TOP

¦^´_ 4# ricky8751

¤j¤j§A¦n¡A¬°¤°»ò§Ú¼g¥X¨Ó¸ò§A¤£¤@¼Ë©O?



¦³­þÃä¼g¿ù©O?   ½Ð±Ð¡C

ÁÂÁÂ
§A¦n

TOP

¦^´_ 5# macacajau


    À³¸Ó¨S¿ù, A14, B14 AND C14 ¿é¤J¬ÛÃö·j´M±ø¥ó¸Õ¸Õ.
=SUMPRODUCT((A2:A11=A14)*(B2:B11=B14)*(C1:G1=C14)*(C2:G11))

TOP

¦^´_ 6# ricky8751

½Ð°Ý¤j¤j A14, B14 AND C14

³o¤T®æ¸Ì­±ÁÙ¦³¼g¤½¦¡¶Ü?

ÁÂÁÂ
§A¦n

TOP

¦^´_ 7# macacajau

¨S¦³¤½¦¡, ¿é¤J­n¬d¸ßªº¤é´Á, ®É¶¡¤Î¨º³¡¾÷ªº¹qÀ£´N¥i¥H.

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD