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

½Ð°Ý¦p¦ó­pºâ¤£¦P¤ÀÃþªºÁ`¼Æ

½Ð°Ý¦p¦ó­pºâ¤£¦P¤ÀÃþªºÁ`¼Æ

A
B
C
D
E
F
G
½s¸¹¤é´Á
¯²¥Î®É¶¡
¯²¥Î³õ¦a ¨C¤p®É¦¬¶O §é¦© Á`­p
1 AM001 01/12/2014 12:00-15:00 Room A
$1000.00
10%$2700.00
2 AM002 01/12/2014 18:00-22:00
Room B
$ 800.00
   0%
$3200.00
3 PM001 02/12/2014 15:00-17:00
Room C
$ 300.00
   0%
$  600.00
4 PM002 02/12/2014
19:00-22:00
Room B
$ 800.00
   0%
$2400.00
5 PM003 03/12/2014 13:00-16:00
Room A
$1000.00
10%
$2700.00
6 AM003 03/12/2014 19:00-22:00 Room C $ 300.00
  0% $ 900.00
7 AM $6800.00
8 PM $5700.00


¦p¤Wªí
½Ð°Ý¦U¦ì«e½ú
¦³¨S¦³¤èªk¦bG7©MG8ªºÀx¦s®æ¸Ì
¤À§O©ñ¤J¤½¦¡
«K¥i­pºâ¥X½s¸¹AM©MPMªº¨â­ÓÁ`¼Æ¡H

¦^´_ 1# K_Wing


    ­n¥ý´£¨Ñ§AAM¡BPMªº©w¸q¬°¦ó??
    °ò¥»¤W¡A§A¹Ï¤ù¤W³ö¦@ªºAM¡BPMªº¥[Á`»P¤W­±²Ó¥Øªº®aÁ`¬O¤@¼Ë¡A
    ¦ý¬O¡A§A­n§PÂ_ªºÅÞ¿è­n¥ý§iª¾¡C
¾Ç²ß¤~¯à´£¤É¦Û¤v

TOP

¦^´_ 2# hugh0620

¥ýÁÂÁÂ¥S§ÌÀ°¦£
·Q±N±a¦³"PM"©M"AM"½s¸¹
¨â¶µ"Á`­p"¤À¶}¨Ó¿W¥ß­pºâ

TOP

¦^´_ 3# K_Wing

G7=SUMIF(A$1:A$6,F7&"*",G$1:G$6) ¤U©Ô

TOP

¦^´_ 4# samwang
·PÁÂ¥S§Ì¦^ÂÐ
§Ú¼È¥¼ª¾¦Û¤v¦b¨º¸Ì§Ë¿ù¤F
¦]¬°­pºâ¥X¨Óªº¼Æ¦r¬OG1¦ÜG6ªº©M
¦ü¥G¨S¦³±NPM½s¸¹©MAM½s¸¹¦U¦Ûªº©M
¤À¶}¿W¥ß­pºâ

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD