SUMIFS - Account Type and Date

[LoriSeely]

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>[TABLE="width: 0"]
<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>[TR]
[TD]Date[/TD]
[TD]Input[/TD]
[TD]Category[/TD]
[TD]Estimated[/TD]
[TD]Actual[/TD]
[TD]Account[/TD]
[TD]Balance-8948[/TD]
[TD]Balance-8142[/TD]
[/TR]
[TR]
[TD="align: right"]11/1/2018[/TD]
[TD]Balance[/TD]
[TD="align: right"]House[/TD]
[TD="align: right"]922.47[/TD]
[TD="align: right"]1182.47[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7E1CD]#B7E1CD[/URL] , align: right"]8948[/TD]
[TD="align: right"]922.47[/TD]
[TD="align: right"]1182.47[/TD]
[/TR]
[TR]
[TD="align: right"]11/3/2018[/TD]
[TD]Meridian Transfer Station[/TD]
[TD="align: right"]Misc.[/TD]
[TD="align: right"]-$39.00[/TD]
[TD="align: right"]-$39.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7E1CD]#B7E1CD[/URL] , align: right"]8948[/TD]
[TD="align: right"]883.47[/TD]
[TD="align: right"]1143.47[/TD]
[/TR]
[TR]
[TD="align: right"]11/3/2018[/TD]
[TD]Super Cuts[/TD]
[TD="align: right"]House[/TD]
[TD="align: right"]-$19.00[/TD]
[TD="align: right"]-$19.00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7E1CD]#B7E1CD[/URL] , align: right"]8948[/TD]
[TD="align: right"]864.47[/TD]
[TD="align: right"]1124.47[/TD]
[/TR]
[TR]
[TD="align: right"]11/3/2018[/TD]
[TD]Chevron[/TD]
[TD="align: right"]Misc.[/TD]
[TD="align: right"]-$6.88[/TD]
[TD="align: right"]-$6.88[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=B7E1CD]#B7E1CD[/URL] , align: right"]8948[/TD]
[TD="align: right"]857.59[/TD]
[TD="align: right"]1117.59[/TD]
[/TR]
[TR]
[TD="align: right"]11/6/2018[/TD]
[TD]RV Loan[/TD]
[TD="align: right"]Auto[/TD]
[TD="align: right"]-$290.02[/TD]
[TD="align: right"]-$290.02[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FCE8B2]#FCE8B2[/URL] , align: right"]8142[/TD]
[TD="align: right"]857.59[/TD]
[TD="align: right"]1117.59[/TD]
[/TR]
</tbody>[/TABLE]

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>[TABLE="width: 0"]
<colgroup><col style="width: 117px"><col width="123"><col width="113"><col width="100"><col width="100"><col width="146"></colgroup><tbody>[TR]
[TD][/TD]
[TD="align: center"]Balance[/TD]
[TD="align: right"]Expenses[/TD]
[TD]Payments[/TD]
[TD]Expected Balance[/TD]
[TD]Actual Balance[/TD]
[/TR]
[TR]
[TD]8948-Main[/TD]
[TD="align: center"]$883.47[/TD]
[TD="bgcolor: #E5E5E5"]#ERROR![/TD]
[TD="bgcolor: #E5E5E5"][/TD]
[TD="bgcolor: #E5E5E5"]$3,446.54[/TD]
[TD="bgcolor: #E5E5E5"]#ERROR![/TD]
[/TR]
[TR]
[TD]8142-House[/TD]
[TD="align: center"]$1,143.47[/TD]
[TD="bgcolor: #E5E5E5"]-$4,626.61[/TD]
[TD="bgcolor: #E5E5E5"][/TD]
[TD="bgcolor: #E5E5E5"]-$437.43[/TD]
[TD="align: right"]-$3,483.14[/TD]
[/TR]
</tbody>[/TABLE]

so that the "Expenses" only include the date that have occurred and today -- Please help have been at this for 5 days endless searching

 

[Fluff]

Hi & welcome to MrExcel
How about
=SUMIFS(E:E,F:F,8948,A:A,"<="&TODAY())

 

[LoriSeely]

Hi & welcome to MrExcel
How about
=SUMIFS(E:E,F:F,8948,A:A,"<="&TODAY())

WOW -- I feel dumb, thank you so much!!

 

[Fluff]

Glad to help & thanks for the feedback

 

[Saidkamol]

So, what about with months. Let's say, I bought several things in November. Sometimes I bought the same things several times. For example apple. On 1st November it cost $1, but on 22nd $1.25. I wanna know how much I've spent to buy apple in month of November among other hundreds of products. Any help would be great. (Sorry, If there any mistake is in my question, I'm not native in English)

 

[Fluff]

Hi & welcome to MrExcel.
Please start a thread of your own.
When you do that please include a sample of your data. If you click on the "tools" link in my signature you will find some add-ins that enable you to post data in a usable form.