Go Back   Cyber Tech Help Support Forums > Software > Applications

Notices

Reply
 
Topic Tools
  #1  
Old September 15th, 2020, 01:05 AM
danlee58 danlee58 is offline
Senior Member
 
Join Date: May 2003
Location: DELAWARE
Age: 80
Posts: 176
Sum of column between two dates in Excel

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.
Reply With Quote


  #2  
Old September 15th, 2020, 09:56 AM
smurfy's Avatar
smurfy smurfy is offline
Cyber Tech Help Moderator
 
Join Date: Sep 2000
O/S: Linux
Location: Christchurch New Zealand
Posts: 9,537
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
Reply With Quote
  #3  
Old September 15th, 2020, 11:04 AM
danlee58 danlee58 is offline
Senior Member
 
Join Date: May 2003
Location: DELAWARE
Age: 80
Posts: 176
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?
Reply With Quote
  #4  
Old September 15th, 2020, 11:57 AM
danlee58 danlee58 is offline
Senior Member
 
Join Date: May 2003
Location: DELAWARE
Age: 80
Posts: 176
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.
Reply With Quote
  #5  
Old September 15th, 2020, 02:06 PM
danlee58 danlee58 is offline
Senior Member
 
Join Date: May 2003
Location: DELAWARE
Age: 80
Posts: 176
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).
Reply With Quote
  #6  
Old September 15th, 2020, 03:02 PM
danlee58 danlee58 is offline
Senior Member
 
Join Date: May 2003
Location: DELAWARE
Age: 80
Posts: 176
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)
Reply With Quote
Reply

Bookmarks

Topic Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump




All times are GMT +1. The time now is 03:24 PM.