Spreadsheet: 844389d1696157594-sum-values-in-a-column-if-another-column-has-a-specific-value-value-changed-dynamically-sumforclassification
Sheet: Sheet1

No | Statement | Main Section | Detailed Items | Classification/Statement | Classification Serial | 2016 | 2017 | 2018 | 2019 | 2020 | 2021
1 | Balance Sheet | [1-1] Non Current Asset | Non Current Asset #1 | Statement | 1 | 64 | 60 | 146 | 131 | 94 | 100
2 | Balance Sheet | [1-1] Non Current Asset | Non Current Asset #2 | Statement | 1 | 86 | 126 | 58 | 54 | 103 | 7
3 | Balance Sheet | [1-1] Non Current Asset | Non Current Asset #3 | Statement | 2 | 62 | 143 | 59 | 45 | 97 | 129
4 | Balance Sheet | [1-1] Non Current Asset | Non Current Asset #4 | Statement | 3 | 125 | 3 | 25 | 24 | 84 | 139
5 | Balance Sheet | [1-1] Non Current Asset | Non Current Asset #5 | Statement | 5 | 109 | 16 | 133 | 74 | 4 | 142
6 | Balance Sheet | [1-2] Current Asset | Current Asset #1 | Statement | 4 | 145 | 106 | 95 | 57 | 15 | 36
7 | Balance Sheet | [1-2] Current Asset | Current Asset #2 | Statement | 3 | 134 | 76 | 93 | 78 | 50 | 144
8 | Balance Sheet | [1-2] Current Asset | Current Asset #3 | Statement | 1 | 119 | 140 | 77 | 2 | 37 | 90
9 | Balance Sheet | [1-2] Current Asset | Current Asset #4 | Statement | 2 | 18 | 44 | 127 | 14 | 43 | 66
10 | Balance Sheet | [1-2] Current Asset | Current Asset #5 | Statement | 5 | 101 | 75 | 28 | 107 | 130 | 61
11 | Balance Sheet | [1-3] Non Current Liabilities | Non Current Liabilities #1 | Statement | 5 | 88 | 19 | 87 | 31 | 51 | 47
12 | Balance Sheet | [1-3] Non Current Liabilities | Non Current Liabilities #2 | Statement | 5 | 46 | 13 | 105 | 147 | 12 | 40
13 | Balance Sheet | [1-3] Non Current Liabilities | Non Current Liabilities #3 | Statement | 5 | 138 | 41 | 34 | 115 | 113 | 72
14 | Balance Sheet | [1-3] Non Current Liabilities | Non Current Liabilities #4 | Statement | 1 | 68 | 48 | 5 | 121 | 108 | 102
15 | Balance Sheet | [1-3] Non Current Liabilities | Non Current Liabilities #5 | Statement | 3 | 149 | 110 | 71 | 21 | 35 | 104
16 | Balance Sheet | [1-4] Current Liabilities | Current Liabilities #1 | Statement | 4 | 80 | 92 | 8 | 29 | 39 | 23
17 | Balance Sheet | [1-4] Current Liabilities | Current Liabilities #2 | Statement | 2 | 128 | 148 | 27 | 112 | 123 | 10
18 | Balance Sheet | [1-4] Current Liabilities | Current Liabilities #3 | Statement | 3 | 132 | 135 | 22 | 124 | 89 | 32
19 | Balance Sheet | [1-4] Current Liabilities | Current Liabilities #4 | Statement | 3 | 69 | 9 | 56 | 150 | 79 | 122
20 | Balance Sheet | [1-4] Current Liabilities | Current Liabilities #5 | Statement | 3 | 30 | 20 | 70 | 117 | 73 | 11
21 | Balance Sheet | [1-5] Owners Equity | Owners Equity #1 | Statement | 1 | 111 | 52 | 42 | 33 | 82 | 118
22 | Balance Sheet | [1-5] Owners Equity | Owners Equity #2 | Statement | 3 | 67 | 17 | 83 | 120 | 63 | 116
23 | Balance Sheet | [1-5] Owners Equity | Owners Equity #3 | Statement | 2 | 6 | 49 | 81 | 137 | 53 | 98
24 | Balance Sheet | [1-5] Owners Equity | Owners Equity #4 | Statement | 4 | 26 | 96 | 65 | 114 | 141 | 85
25 | Balance Sheet | [1-5] Owners Equity | Owners Equity #5 | Statement | 1 | 99 | 1 | 55 | 91 | 136 | 38
26 | Balance Sheet | [1-6] Classifications | Classifications #1 | Classification | 1
27 | Balance Sheet | [1-6] Classifications | Classifications #2 | Classification | 2
28 | Balance Sheet | [1-6] Classifications | Classifications #3 | Classification | 3
29 | Balance Sheet | [1-6] Classifications | Classifications #4 | Classification | 4
30 | Balance Sheet | [1-6] Classifications | Classifications #5 | Classification | 5
 |  |  |  |  |  | For example, the cell colored in yellow will Sum all values in column G, if cell in the same row for column F, equal the same number in current cell row in column F, so for example, current number in column F for the current row is 1, so we should sum all cells in column G that has 1 in its associated row in column F which in this case, f1,f2,f9,f15,f22 and f26