Hi ,
I have values for a year in excel and in the row sum i want to sum the total of 1,2,3, and in the return row if i dont have a value in consecutive months then i should minus that value from total. For ex below month 1. in jan i have 4900 however next two months the value is 0, hence it should be minus from the total value,
Can you please help me with the formula which can check the consecutive value. Note: There are rows where we dont have any values for the year.
In a month if we have a value >0, then it should check we have consecutive number for that particular row. is it possible?
<colgroup><col><col span="12"></colgroup><tbody>
</tbody>
I have values for a year in excel and in the row sum i want to sum the total of 1,2,3, and in the return row if i dont have a value in consecutive months then i should minus that value from total. For ex below month 1. in jan i have 4900 however next two months the value is 0, hence it should be minus from the total value,
Can you please help me with the formula which can check the consecutive value. Note: There are rows where we dont have any values for the year.
In a month if we have a value >0, then it should check we have consecutive number for that particular row. is it possible?
| Month | Jan-18 | Feb-18 | Mar-18 | Apr-18 | May-18 | Jun-18 | Jul-18 | Aug-18 | Sep-18 | Oct-18 | Nov-18 | Dec-18 |
| 1 | $4,900.00 | $0.00 | $0.00 | $0.00 | $ | $ | $ | $ | $ | $ | $ | $ |
| 2 | $4,938.68 | $4,146.70 | $4,146.70 | $4,146.70 | $ | $ | $ | $ | $ | $ | $ | $ |
| 3 | $0.00 | $0.00 | $0.00 | $0.00 | $ | $ | $ | $ | $ | $ | $ | $ |
| Sum | $9,838.68 | $4,146.70 | $4,146.70 | $4,146.70 | ||||||||
| Return | $4,938.68 |
<colgroup><col><col span="12"></colgroup><tbody>
</tbody>
