Sum of column between two dates in Excel

[danlee58]

I am trying to get a Sum of a column, between two dates. Column A has a list of dates, and Column D has dollar values. Here is the Excel formula. It does not return an answer.

=SUMIFS(D38,A3:A8,">=14-SEP-20119",A3:A8,"<=20-SEP-2019")

I don't get errors with this formula.

Is my Excel 2000? version too old.

[smurfy]

I will need to double-check but pretty sure that wont work in Excel 2000. Have you tried using the Conditional Sum Wizard add-in? https://www.ozgrid.com/Excel/sum-wizard.htm

[danlee58]

I need the Microsoft Office 2000 CD to load the Conditional Sum Wizard. I believe that I still have it, but I have to look for it. Would I be better off just getting an Upgrade for Office or Excel?

[danlee58]

I loaded Office Live, and uploaded my Excel file to One Drive. Now I have:

=@SUMIFS(D3300,A3:A300,">="&E3,A3:A300,"<="&E4)

This does work. I can sum between any dates in E3, and E4. I can simply change the dates to get different periods. Ultimately, I would like a running Sum of 30 days for the entire list.

[danlee58]

I now have a running sum of 1 month with this formula.

=@SUMIFS(D3300,A3:A300,">="&E3,A3:A300,"<="&F3)

Cell E3 contains the same date as Cell A3, but Cell F3 contains =EDATE(E3, 1). I just copy this down the column. It's summing the next month, but I want the past month. I'll try =EDATE(E3, -1).

[danlee58]

I got =EDATE(E3, -1) to give me the previous month, but it only wants to use the future dates for summing. Here is my current formula:
=@SUMIFS(D3300,A3:A300,">="&E3,A3:A300,"<="&F3)