I'm trying to "upgrade" a spreadsheet I use for monthly ACH payments.
I want to be able to change the month in cell A3, add an X or other characters in various rows, and have a total returned.
Currently, I have to move "fields" each month in order for the totals to work.
Here is the best example I'm able to provide, as the grid lines aren't showing up.
<tbody>
</tbody><colgroup><col><col span="4"><col><col><col><col><col><col></colgroup>
I want to be able to change the month in cell A3, add an X or other characters in various rows, and have a total returned.
Currently, I have to move "fields" each month in order for the totals to work.
Here is the best example I'm able to provide, as the grid lines aren't showing up.
| Residential ACH Tenants | ## | X | Indicates Batch has been sent to National City | |||||||
| Effective Month | ||||||||||
| 1-Jan-17 | Bldg | Normal Monthly Amount | New Monthly Amount Eff: 11/01/15 | Amount This Month | Oct-16 | Nov-16 | Dec-16 | Jan-17 | ||
| Master | ||||||||||
| None currently in effect. | <strike> $ - </strike> | |||||||||
| $ - | <- Total withdrawal | |||||||||
| 1st of each Month | ||||||||||
| ## | ## | $ 415.00 | X | X | X | 3rd | ||||
| ## | ## | $ 460.00 | X | X | X | 3rd | ||||
| $ 875.00 | <- Total withdrawal |
<tbody>
</tbody><colgroup><col><col span="4"><col><col><col><col><col><col></colgroup>
