I am trying to have a rolling sum to calculate based on the account type and include today and previous dates - I cannot get the SUMIFS function right (or if this is even possible):
=SUMIFS(E:E,F:F,"8948",A:A,">=Today()")
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="125"><col width="100"><col width="117"><col width="117"></colgroup><tbody>
</tbody>
Trying to sum "Actual" if "Account=8948 or 8142" and "Date" is Today or Previous
So that I can generate this table:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 117px"><col width="123"><col width="113"><col width="100"><col width="100"><col width="146"></colgroup><tbody>
</tbody>
so that the "Expenses" only include the date that have occurred and today -- Please help have been at this for 5 days endless searching
=SUMIFS(E:E,F:F,"8948",A:A,">=Today()")
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Date | Input | Category | Estimated | Actual | Account | Balance-8948 | Balance-8142 |
11/1/2018 | Balance | House | 922.47 | 1182.47 | 8948 | 922.47 | 1182.47 |
11/3/2018 | Meridian Transfer Station | Misc. | -$39.00 | -$39.00 | 8948 | 883.47 | 1143.47 |
11/3/2018 | Super Cuts | House | -$19.00 | -$19.00 | 8948 | 864.47 | 1124.47 |
11/3/2018 | Chevron | Misc. | -$6.88 | -$6.88 | 8948 | 857.59 | 1117.59 |
11/6/2018 | RV Loan | Auto | -$290.02 | -$290.02 | 8142 | 857.59 | 1117.59 |
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="125"><col width="100"><col width="117"><col width="117"></colgroup><tbody>
</tbody>
Trying to sum "Actual" if "Account=8948 or 8142" and "Date" is Today or Previous
So that I can generate this table:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Balance | Expenses | Payments | Expected Balance | Actual Balance | |
8948-Main | $883.47 | #ERROR! | $3,446.54 | #ERROR! | |
8142-House | $1,143.47 | -$4,626.61 | -$437.43 | -$3,483.14 |
<colgroup><col style="width: 117px"><col width="123"><col width="113"><col width="100"><col width="100"><col width="146"></colgroup><tbody>
</tbody>
so that the "Expenses" only include the date that have occurred and today -- Please help have been at this for 5 days endless searching