Spreadsheet: 743403d1628481261-sum-a-range-of-rows-in-a-column-on-another-sheet-but-stipulating-which-column-from-a-cell-example
Sheet: Reserves Input

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | K-2ST1 |  |  |  |  |  |  |  |  |  |  |  |  |  | K-4
 |  | ABC |  |  |  |  |  |  |  |  |  |  |  |  |  | ABC |  |  |  |  |  |  |  |  |  |  |  |  |  | ABC
 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | K-2ST1 |  |  |  |  |  |  |  |  |  |  |  |  |  | K-4
 |  |  |  | Production |  |  |  |  |  | Injection |  |  |  |  |  |  |  | Production |  |  |  |  |  | Injection |  |  |  |  |  |  |  | Production |  |  |  |  |  | Injection
 |  | well event # | Time onstream | Oil | Gas (net of gaslift) |  | Water | Lift gas |  | Gas |  | Water | THP | [NAME] |  | well event # | Time onstream | Oil | Gas (net of gaslift) |  | Water | Lift gas |  | Gas |  | Water | THP | [NAME] |  | well event # | Time onstream | Oil | Gas (net of gaslift) |  | Water | Lift gas |  | Gas |  | Water | THP | [NAME]
 | Date |  | hrs | m3 | m3 | GJ | m3 | m3 | GJ | m3 | GJ | m3 | barg |  |  |  | hrs | m3 | m3 | GJ | m3 | m3 | GJ | m3 | GJ | m3 | barg |  |  |  | hrs | m3 | m3 | GJ | m3 | m3 | GJ | m3 | GJ | m3 | barg
 | 2009-01-01 00:00:00 |  | 24 | 4.754075715273428 | 1712.493484399593 |  | 1.774541800333632 | 16100 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1712.493484399593 |  | 1.774541800333632 | 16100 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1712.493484399593 |  | 1.774541800333632 | 16100 |  | 0 |  | 0 | 6
 | 2009-01-02 00:00:00 |  | 24 | 4.754075715273428 | 1855.515240010873 |  | 1.774541800333632 | 15406 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1855.515240010873 |  | 1.774541800333632 | 15406 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1855.515240010873 |  | 1.774541800333632 | 15406 |  | 0 |  | 0 | 6
 | 2009-01-03 00:00:00 |  | 24 | 4.754075715273428 | 1938.454932324458 |  | 1.774541800333632 | 15001 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1938.454932324458 |  | 1.774541800333632 | 15001 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1938.454932324458 |  | 0.3 | 15001 |  | 0 |  | 0 | 6
 | 2009-01-04 00:00:00 |  | 24 | 4.754075715273428 | 1635.557905912422 |  | 1.774541800333632 | 15813 |  | 0 |  | 0 | 4 |  |  |  | 24 | 4.754075715273428 | 1635.557905912422 |  | 1.774541800333632 | 15813 |  | 0 |  | 0 | 4 |  |  |  | 24 | 4.754075715273428 | 1635.557905912422 |  | 1.774541800333632 | 15813 |  | 0 |  | 0 | 4
 | 2009-01-05 00:00:00 |  | 24 | 4.754075715273428 | 1921.645907924652 |  | 1.774541800333632 | 9396 |  | 0 |  | 0 | 4 |  |  |  | 24 | 4.754075715273428 | 1921.645907924652 |  | 0.5 | 9396 |  | 0 |  | 0 | 4 |  |  |  | 24 | 4.754075715273428 | 1921.645907924652 |  | 1.774541800333632 | 9396 |  | 0 |  | 0 | 4
 | 2009-01-06 00:00:00 |  | 24 | 4.754075715273428 | 1746.894986788061 |  | 0 | 18191 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1746.894986788061 |  | 1.774541800333632 | 18191 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1746.894986788061 |  | 0.2 | 18191 |  | 0 |  | 0 | 6
 | 2009-01-07 00:00:00 |  | 24 | 4.754075715273428 | 1667.396800470663 |  | 1.774541800333632 | 10030 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1667.396800470663 |  | 1.774541800333632 | 10030 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1667.396800470663 |  | 1.774541800333632 | 10030 |  | 0 |  | 0 | 6
 | 2009-01-08 00:00:00 |  | 24 | 4.754075715273428 | 1752.615633178175 |  | 1.774541800333632 | 12081 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1752.615633178175 |  | 1.774541800333632 | 12081 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1752.615633178175 |  | 1.774541800333632 | 12081 |  | 0 |  | 0 | 6
 | 2009-01-09 00:00:00 |  | 24 | 4.754075715273428 | 1809.033410808232 |  | 1.774541800333632 | 14858 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1809.033410808232 |  | 0.7 | 14858 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1809.033410808232 |  | 1.774541800333632 | 14858 |  | 0 |  | 0 | 6
 | 2009-01-10 00:00:00 |  | 24 | 4.754075715273428 | 2032.203083574177 |  | 1.774541800333632 | 11832 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 2032.203083574177 |  | 1.774541800333632 | 11832 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 2032.203083574177 |  | 0.1 | 11832 |  | 0 |  | 0 | 6
 | 2009-01-11 00:00:00 |  | 24 | 4.754075715273428 | 1502.153203258802 |  | 1.2 | 13840 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1502.153203258802 |  | 1.774541800333632 | 13840 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1502.153203258802 |  | 1.774541800333632 | 13840 |  | 0 |  | 0 | 6
 | 2009-01-12 00:00:00 |  | 24 | 4.754075715273428 | 1809.150708923616 |  | 1.774541800333632 | 12850 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1809.150708923616 |  | 1.774541800333632 | 12850 |  | 0 |  | 0 | 6 |  |  |  | 24 | 4.754075715273428 | 1809.150708923616 |  | 1.774541800333632 | 12850 |  | 0 |  | 0 | 6
 | 2009-01-13 00:00:00 |  | 24 | 4.754075715273428 | 1643.191738009005 |  | 1.774541800333632 | 16501 |  | 0 |  | 0 | 7 |  |  |  | 24 | 4.754075715273428 | 1643.191738009005 |  | 0.4 | 16501 |  | 0 |  | 0 | 7 |  |  |  | 24 | 4.754075715273428 | 1643.191738009005 |  | 1.774541800333632 | 16501 |  | 0 |  | 0 | 7
 | 2009-01-14 00:00:00 |  | 24 | 4.754075715273428 | 1441.938206646363 |  | 1.774541800333632 | 10872 |  | 0 |  | 0 | 7 |  |  |  | 24 | 4.754075715273428 | 1441.938206646363 |  | 1.774541800333632 | 10872 |  | 0 |  | 0 | 7 |  |  |  | 24 | 4.754075715273428 | 1441.938206646363 |  | 1.774541800333632 | 10872 |  | 0 |  | 0 | 7
 | 2009-01-15 00:00:00 |  | 24 | 4.346583511107135 | 1784.894267627579 |  | 0.207144957237389 | 13416 |  | 0 |  | 0 | 8 |  |  |  | 24 | 4.346583511107135 | 1784.894267627579 |  | 0.207144957237389 | 13416 |  | 0 |  | 0 | 8 |  |  |  | 24 | 4.346583511107135 | 1784.894267627579 |  | 0.207144957237389 | 13416 |  | 0 |  | 0 | 8