# Last 180 Days Formula

1. ## Last 180 Days Formula

Hello,

I am having trouble creating a formula that will find rows that have a date in the last 180 days, and then use the sum of a specific column in those rows.

ie:

Date Total

June 3, 2013 4 <---- Use This Data
April 4, 2013 4 <---- Use This Data
April 9, 2013 1 <---- Use This Data
January 7, 2013 7 x-----Do Not Use This Number

Sum
9

Thanks

2. ## Re: Last 180 Days Formula

Why would January 7, 2013 be excluded? It's within today minus 180 days.

Today = 6/16/2013

6/16/2013 - 180 days = 12/18/2012

3. ## Re: Last 180 Days Formula

Maybe you want:

180 days prior to current date
=SUMIF(A1:A20,">="&TODAY()-180,B1:B20)

180 days prior to most recent date
=SUMIF(A1:A20,">="&MAX(A1:A20)-180,B1:B20)

4. ## Re: Last 180 Days Formula

Originally Posted by Tony Valko
Why would January 7, 2013 be excluded? It's within today minus 180 days.

Today = 6/16/2013

6/16/2013 - 180 days = 12/18/2012
Oops! Been a long day, should be January 7, 2012!

Thanks, that looks like what I'm looking for!

5. ## Re: Last 180 Days Formula

OK, then this should do what you want.

=SUMIF(A2:A5,">="&TODAY()-180,B2:B5)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1