Hi,
In the below Example the value of cell M2: 387 is arrived by using the formula =SUM(L3:L9)
and M10: 418 is arrived by using the formula =SUM(L11:L17)
i.e , Need to sum the integers in-between two "Day-IN"s
Challange: There is more than 1000 records(more than 500 "Day-IN"s) for which I cannot manually use Sum for the cells in-between "Day-IN"s
<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>
Refer Image : View image: Sum between cells
Someone, Kindly shed some light pls...
In the below Example the value of cell M2: 387 is arrived by using the formula =SUM(L3:L9)
and M10: 418 is arrived by using the formula =SUM(L11:L17)
i.e , Need to sum the integers in-between two "Day-IN"s
Challange: There is more than 1000 records(more than 500 "Day-IN"s) for which I cannot manually use Sum for the cells in-between "Day-IN"s
1</SPAN> | L </SPAN> | M</SPAN> |
2</SPAN> | Day-IN | 387</SPAN> |
3</SPAN> | 112</SPAN> | |
4</SPAN> | -65</SPAN> | |
5</SPAN> | 90</SPAN> | |
6</SPAN> | -4</SPAN> | |
7</SPAN> | 115</SPAN> | |
8</SPAN> | -47</SPAN> | |
9</SPAN> | 70</SPAN> | |
10</SPAN> | Day-IN</SPAN> | 418</SPAN> |
11</SPAN> | 128</SPAN> | |
12</SPAN> | -56</SPAN> | |
13</SPAN> | 144</SPAN> | |
14</SPAN> | -5</SPAN> | |
15</SPAN> | 64</SPAN> | |
16</SPAN> | -38</SPAN> | |
17</SPAN> | 82</SPAN> | |
18</SPAN> | Day-IN</SPAN> | 383</SPAN> |
19</SPAN> | 86</SPAN> | |
20</SPAN> | -0</SPAN> | |
21</SPAN> | 1</SPAN> | |
22</SPAN> | -51</SPAN> | |
23</SPAN> | 95</SPAN> | |
24</SPAN> | -6</SPAN> | |
25</SPAN> | 130</SPAN> | |
26</SPAN> | -56</SPAN> | |
27</SPAN> | 71</SPAN> | |
28</SPAN> | Day-IN</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>
Refer Image : View image: Sum between cells
Someone, Kindly shed some light pls...