Re: How do I add items within the last 12 months?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ron Rosenfeld <ronrosenfeld@xxxxxxxxxx>
Date: Tue, 18 Oct 2005 21:27:51 -0400

On Tue, 18 Oct 2005 17:42:02 -0700, "Kevbro7189"
<Kevbro7189@xxxxxxxxxxxxxxxxxxxxxxxxx> 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
.

Prev by Date: Re: IF Statement
Next by Date: Re: Finding the average across multiple sheets
Previous by thread: Re: IF Statement
Next by thread: Re: Finding the average across multiple sheets
Index(es):
- Date
- Thread

Relevant Pages

Count years in date range
... I have two columns in a table; one name StartDate, ... EndDate. ... Each table refers to a user and details, obviously, their start ... Prev by Date: ...
(microsoft.public.access.queries)
Re: Concatenating text fields with a WHERE condition
... You have to pass the StartDate and EndDate into the function, ... Function fConcatChild(strChildTable As String, _ ... Prev by Date: ...
(comp.databases.ms-access)
Questions on appts collection (Calendar)
... I get duplicates (subject, startdate, enddate) sometimes. ... Prev by Date: ...
(comp.groupware.groupwise)
Number of Days in Month
... Do While StartDate < EndDate ... Loop ... Prev by Date: ...
(microsoft.public.access.modulesdaovba)
Re: Calculate Age in table from Date of Birth and Current Date (MS
... 'StartDate' and 'EndDate' cross-references in the with ASK fields to solicit ... you might see where the bookmarks and fields are more easily if you ...
(microsoft.public.word.tables)