CHAPTER 03 SUM VLOOKUP
3-3 3-4 3-5 3-6 1 2 03 04 05 06 A3 3-3 A4 1 3-4 1 3-5 Ctrl Ctrl 3-6 045 009
013 \ \03\ \.xlsx \ \03\ \.xlsx 3-53 3-54 01 02 063 3-53 3-54 013
01 0203 03 3-55 04 A5 A9 3-55 H2 3-56 08 04050607 064 3-56 1 2 3-57 3-58 05 06 = 3-57 H2 3-58
CHAPTER 04 Excel
04 02 01 018 \ \04\ \.xlsx 01 05 4-1 0602 07 1 2 4-2 08076 03 B3 B29 4-1,,,, 4-2
CHAPTER 06 1 YEAR MONTH SLN ROUND ROW / DB SYD DDB INDEX MATCH
06 01 035 0203 \ \06\ \.xlsx 04 01 05 6-1 02 07 08 6-2 132 6-1 C3 6-2
04 0507 0103 0608 02 07 6-7 6-8 YEAR MONTH YEAR 1900 9999 YEAR(serial_number) serial_number MONTH Variant (Integer) 1 12 MONTH(date) date Variant date Null Null YEAR MONTH 134 08 P4 =(YEAR($P$2)-YEAR (H4)-1)*12+(12-MONTH(H4)) +MONTH($P$2) Enter 6-7 6-8
06 01 039 0203 \ \06\ \.xlsx \ \06\ \.xlsx 04 01 05 6-42 02 1 072 08 3 6-43 148 \ \06\ \.xlsx 6-42 6-43
6-44 6-45 6-46 03 04 05 6-44 B9 =DDB($E$4,$G$4,$D$4,A9) Enter 6-45 6-46 149 039
6-67 6-68 21 22 B3 6-67 6-68 157 INDEX MATCH INDEX INDEX MATCH 040