Hi
Need some help here
I want to be able to find the sum of November 1 to the current day of the month (will automatically update based on what day it is today)
For example if today is 11 I want it to calculate the sum of the first 11 cells in column b which should return the value ($406,489.97)
if today is the the 13 i want it to calculate the sum of the first 13 cells in column b which should return the value ($432,186.95)
and so on
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<tbody>
</tbody>
Need some help here
I want to be able to find the sum of November 1 to the current day of the month (will automatically update based on what day it is today)
For example if today is 11 I want it to calculate the sum of the first 11 cells in column b which should return the value ($406,489.97)
if today is the the 13 i want it to calculate the sum of the first 13 cells in column b which should return the value ($432,186.95)
and so on
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
| Date | November 2017 |
| 1 | $68,984.28 |
| 2 | $17,715.00 |
| 3 | $2,380.00 |
| 4 | $0.00 |
| 5 | $0.00 |
| 6 | $29,774.86 |
| 7 | $149,187.94 |
| 8 | $9,998.00 |
| 9 | $9,384.05 |
| 10 | $119,065.84 |
| 11 | $0.00 |
| 12 | $0.00 |
| 13 | $25,696.98 |
| 14 | $45,340.68 |
| 15 | $6,681.05 |
| 16 | $4,838.45 |
| 17 | $40,386.99 |
| 18 | $0.00 |
| 19 | $0.00 |
| 20 | $146,016.49 |
| 21 | $202,543.70 |
| 22 | $1,600.00 |
| 23 | $0.00 |
| 24 | $0.00 |
| 25 | $0.00 |
| 26 | $0.00 |
| 27 | $50,823.58 |
| 28 | $24,879.85 |
| 29 | $12,747.39 |
| 30 | $24,600.07 |
| 31 | - |
| Deposits Total | $992,645.20 |
<tbody>
</tbody>
Last edited:
