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
|