Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add items within the last 12 months?
I want to add up numbers that only happened within the last 12 months from
the current date. I do have a column with the date I want to reference to. |
#2
|
|||
|
|||
How do I add items within the last 12 months?
Assuming that Column A contains the date, and Column B contains the
numbers, try... =SUMIF(A1:A100,"="&TODAY()-365,B1:B100) Hope this helps! In article , "Kevbro7189" wrote: I want to add up numbers that only happened within the last 12 months from the current date. I do have a column with the date I want to reference to. |
#3
|
|||
|
|||
How do I add items within the last 12 months?
If the figures to conditionally add are in column B, and the dates are in A,
=SUMIF(A:A,"=" & TODAY()-365,B:B) would add up all the values from the past 366 days (including the current day). Use that anywhere except in columns A or B (in A or B you'll get a circular reference). "Kevbro7189" wrote: I want to add up numbers that only happened within the last 12 months from the current date. I do have a column with the date I want to reference to. |
#4
|
|||
|
|||
How do I add items within the last 12 months?
On Tue, 18 Oct 2005 17:42:02 -0700, "Kevbro7189"
wrote: I want to add up numbers that only happened within the last 12 months from the current date. I do have a column with the date I want to reference to. If your column of dates is named "dates" and your column of numbers is named "numbers" then: A1: StartDate of period of interest A2: EndDate of period of interest =SUMIF(dates,"="&A1,numbers) - SUMIF(dates,""&A2,numbers) should do it. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Dates in Terms of Months | Excel Worksheet Functions | |||
months between 2 dates!!! | Excel Discussion (Misc queries) | |||
Why "datedif" function results sometimes negative numbers? | Excel Worksheet Functions | |||
How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) |