#1
|
|||
|
|||
Sum Function over Today +/- 60 Days
Hello,
I am trying to get a formula to SUM numbers over multiple rows over a specific date range (Today + and - 60 days, totaling 120 days). The sum function is working fine, but for some reason I cannot get it to only take the specific date range into account. Excel is not indicating any error. =SUMIF('CY1 (2)'!D7:NE22,"<=" &TODAY()-60)+SUMIF('CY1 (2)'!D7:NE22,"=" &TODAY()+60) Looking at the picture below, it should only show 3 summing the 120 days in question, but it is adding the one I have placed in January and the one I placed in December, totaling 5. |
#2
|
|||
|
|||
I don't think that equation is going to do what you want. I copied the equation to a spreadsheet and changed the range. I checked it in the formula builder and it says the criteria is volatile. Whenever I added any number to the range, it simply incremented the result with the value.
What are you trying to do? Are you just trying to add those data under the dates that meet the criteria? Are the digits in Row 2 dates formatted to just show the date? That would make it easier. Simpler still, forget putting the month in Row 1 and just put the complete date in Row 2. Also, check your criteria. You are asking to sum all dates earlier than 60 days ago and one date 60 days from now. How this can be done is eluding me now. It's late and I need to hit the rack. |
#3
|
||||
|
||||
Please post a sample sheet
How are your dates formatted in the table? Is the word " september" in a merged cell? Are the days the real date format as "dd" ?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using Outlook Today Calendar Days | cwksr | Outlook | 0 | 08-13-2014 10:57 AM |
How do I auto-update the TODAY excel function within PowerPoint show presentation? | Powerpoint100 | PowerPoint | 0 | 02-12-2013 01:45 PM |
Today's Date Function | freschij | Excel | 3 | 02-11-2011 10:21 AM |
Conditional formatting of Today +21 days? | SHERMAN | Excel | 3 | 12-20-2010 08:08 AM |
Creating an Auto-Calc'd Date? Today+7 Days? | SoCalTelephone | Word | 0 | 10-06-2010 10:27 AM |