Go Back   Cyber Tech Help Support Forums > Software > Applications

Notices

Applications Use this board for problem solving and the discussion of computer software applications

Reply
 
Topic Tools
  #1  
Old September 15th, 2020, 01:05 AM
danlee58 danlee58 is offline
Senior Member
 
Join Date: May 2003
Location: DELAWARE
Age: 82
Posts: 177
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,538
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: 82
Posts: 177
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: 82
Posts: 177
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: 82
Posts: 177
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: 82
Posts: 177
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

Similar Topics
Topic Topic Starter Forum Replies Last Post
Excel 2007 - Unlocking cells in one column based on values in another column Marriott Applications 0 June 14th, 2010 05:53 PM
Hide/Show column and row headings in Excel? deronsizemore Applications 1 September 16th, 2006 06:23 AM
Excel Keeps Changing My Numbers to Dates heathabear Applications 1 January 29th, 2004 11:34 PM
Excel Column Border Missing Delphi123 Applications 4 October 17th, 2003 11:21 PM




All times are GMT +1. The time now is 07:49 PM.