Space_Cowboy
New Member
- Joined
- Oct 12, 2017
- Messages
- 6
Please see below. Row 3 is the header row. data contained in (b3:c12). I am looking for a way to automatically look for the last 12 populated cells in (b3:c12), and place the result in d13. for example, in the below sample data, d13 should sum (C4:C9)+(B7:B12) for a value of 71. When I later add data to cell c10, I need for d13 to now sum (C4:C10)+(b8:b12), and so on. When the data is down to d12, the next data value will be in d4 and the calculation in d13 will appear in e13. Is therre a way to do this?
<tbody>
</tbody>
b | c | d | |
3 | 2016 | 2017 | |
4 | 5 | 4 | |
5 | 3 | 4 | |
6 | 4 | 5 | |
7 | 2 | 7 | |
8 | 9 | 12 | |
9 | 1 | 12 | |
10 | 4 | ||
11 | 8 | ||
12 | 3 | ||
13 | ddd | ||
14 | |||
15 | |||
26 |
<tbody>
</tbody>