| Date | Invoice | Invoice amount |
| 01-10-17 | INV1 | 3,361.00 |
| 01-10-17 | INV2 | 2,160.00 |
| 01-10-17 | INV3 | 690.00 |
| 01-10-17 | INV4 | 720.00 |
| 01-10-17 | INV5 | 100.00 |
| 01-10-17 | INV6 | 7,599.00 |
| 01-10-17 | INV7 | 8,250.00 |
| 01-10-17 | INV8 | 1,680.00 |
| 01-10-17 | INV9 | 10,179.00 |
| 01-10-17 | INV10 | 2,040.00 |
| 01-10-17 | INV11 | 2,520.00 |
| 01-10-17 | INV12 | 690.00 |
| 01-10-17 | INV13 | 2,160.00 |
| 01-10-17 | INV14 | 6,258.00 |
| 01-10-17 | INV15 | 690.00 |
| 01-10-17 | INV16 | 2,400.00 |
| 01-10-17 | INV17 | 200.00 |
| 01-10-17 | INV18 | 200.00 |
| 01-10-17 | INV19 | 1,404.00 |
| 01-10-17 | INV20 | 7,425.00 |
| 01-10-17 | INV21 | 3,450.00 |
| 01-10-17 | INV22 | 702.00 |
| 01-11-17 | INV23 | 351.00 |
| 01-11-17 | INV24 | 6,720.00 |
| 01-11-17 | INV25 | 7,152.00 |
| 01-11-17 | INV26 | 300.00 |
| 01-11-17 | INV27 | 1,053.00 |
| 01-11-17 | INV28 | 9,828.00 |
| 01-11-17 | INV29 | 1,380.00 |
| 01-11-17 | INV30 | 5,395.00 |
| 01-11-17 | INV31 | 3,984.00 |
| 01-11-17 | INV32 | 224.80 |
| 01-11-17 | INV33 | 168.60 |
| 01-11-17 | INV34 | 112.40 |
| 01-11-17 | INV35 | 660.00 |
| 01-11-17 | INV36 | 639.00 |
| 01-11-17 | INV37 | 192.00 |
| 01-11-17 | INV38 | 4,800.00 |
| 01-11-17 | INV39 | 375.00 |
| 01-11-17 | INV40 | 426.00 |
| 01-11-17 | INV41 | 4,482.00 |
| 01-11-17 | INV42 | 1,620.00 |
| 01-11-17 | INV43 | 990.00 |
| 01-11-17 | INV44 | 449.60 |
| 01-11-17 | INV45 | 224.80 |
| 01-11-17 | INV46 | 2,075.00 |
| 01-11-17 | INV47 | 5,478.00 |
| 01-11-17 | INV48 | 213.00 |
| 01-11-17 | INV49 | 639.00 |
| 01-11-17 | INV50 | 1,440.00 |
| 01-12-17 | INV51 | 990.00 |
| 01-12-17 | INV52 | 3,984.00 |
| 01-12-17 | INV53 | 4,565.00 |
| 01-12-17 | INV54 | 393.40 |
| 01-12-17 | INV55 | 110.00 |
| 01-12-17 | INV56 | 660.00 |
| 01-12-17 | INV57 | 2,800.00 |
| 01-12-17 | INV58 | 1,200.00 |
| 01-12-17 | INV59 | 1,080.00 |
| 01-12-17 | INV60 | 639.00 |
| 01-12-17 | INV61 | 540.00 |
| 01-12-17 | INV62 | 1,494.00 |
| 01-12-17 | INV63 | 639.00 |
| 01-12-17 | INV64 | 639.00 |
| 01-12-17 | INV65 | 1,600.00 |
| 01-12-17 | INV66 | 4,950.00 |
| 01-12-17 | INV67 | 1,680.00 |
| 01-12-17 | INV68 | 1,620.00 |
| 01-12-17 | INV69 | 540.00 |
| 01-12-17 | INV70 | 540.00 |
| 01-12-17 | INV71 | 2,075.00 |
| 01-12-17 | INV72 | 2,490.00 |
| 01-12-17 | INV73 | 2,905.00 |
| 01-12-17 | INV74 | 330.00 |
| 01-12-17 | INV75 | 2,000.00 |
| 01-12-17 | INV76 | 1,200.00 |
| 01-12-17 | INV77 | 3,960.00 |
| 01-12-17 | INV78 | 990.00 |
| 01-12-17 | INV79 | 83.00 |
| 01-12-17 | INV80 | 332.00 |
| 01-12-17 | INV81 | 249.00 |
| 01-12-17 | INV82 | 249.00 |
| 01-12-17 | INV83 | 332.00 |
| 02-01-18 | INV84 | 166.00 |
| 02-01-18 | INV85 | 224.80 |
| 02-01-18 | INV86 | 249.00 |
| 02-01-18 | INV87 | 3,960.00 |
| 02-01-18 | INV88 | 4,950.00 |
| 02-01-18 | INV89 | 390.00 |
| 02-01-18 | INV90 | 1,080.00 |
| 02-01-18 | INV91 | 330.00 |
| 02-01-18 | INV92 | 660.00 |
| 02-01-18 | INV93 | 1,065.00 |
| 02-01-18 | INV94 | 1,065.00 |
| 02-01-18 | INV95 | 576.00 |
| 02-01-18 | INV96 | 426.00 |
| 02-01-18 | INV97 | 426.00 |
| 02-01-18 | INV98 | 639.00 |
| 02-01-18 | INV99 | 3,735.00 |
| 02-01-18 | INV100 | 1,245.00 |
| 02-01-18 | INV101 | 415.00 |
| 02-01-18 | INV102 | 830.00 |
| 02-01-18 | INV103 | 770.00 |
| 02-01-18 | INV104 | 130.00 |
| 02-01-18 | INV105 | 130.00 |
| 02-01-18 | INV106 | 190.40 |
| 02-01-18 | INV107 | 1,080.00 |
| 02-01-18 | INV108 | 2,040.00 |
| 02-01-18 | INV109 | 3,910.00 |
| 02-02-18 | INV110 | 3,060.00 |
| 02-02-18 | INV111 | 222.00 |
| 02-02-18 | INV112 | 1,200.00 |
| 02-02-18 | INV113 | 540.00 |
| 02-02-18 | INV114 | 2,000.00 |
| 01-03-18 | INV115 | 1,980.00 |
| 01-03-18 | INV116 | 3,960.00 |
| 01-03-18 | INV117 | 2,430.00 |
| 01-03-18 | INV118 | 5,880.00 |
| Total | 226,062.80 |
LoveDingdong 發表於 18-10-23 23:07
樓主，想問一下如圖（參考）既：
1）公司好多時excel都會有好多Formula, 而我通常都會按向下填滿如c 這直行 ...
發表於 
麻煩解答。應該好易。但我就是不懂
返回列表
