sum values between today and 6 months prior

G

Guest

I have a colum with exact dates and another with values that correspond to
those dates. Columns D and E respectively. Rows 7-36. What I would like to do
in another cell is total the values entered in E for the a date range in D
between today and 6 months prior to todays date.
 
J

Jason Morin

Try:

=SUMPRODUCT((D7:D36>=DATE(YEAR(TODAY()),MONTH(TODAY())-
6,DAY(TODAY())))*(TODAY()>=D7:D36)*E7:E36)

HTH
Jason
Atlanta, GA
 
G

Guest

It works...thanks!
=SUMPRODUCT((D7:D36>=DATE(YEAR(TODAY()),MONTH(TODAY())-
6,DAY(TODAY())))*(TODAY()>=D7:D36)*E7:E36)

I'd like to add to that formula. I want to use this formula on a monthly
basis in different cells. I want to make it so in January it would use today
and 6 months prior to today but when January ends it would automatically
default to looking for Jan 31st and 6 months prior.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding/omitting/all the values prior to todays date 2
Pivot table macro filter data between yesterday and today (date+time) 0
Another Date Formula Request 1
Excel Help with dates 2
date computing and sum issues 6
Adding values for prior date intervals 1
Sum value between two dates and copy to new cell 6
SUM values between dates 1

Top