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
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
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
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)
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Oops! Been a long day, should be January 7, 2012!Originally Posted by Tony Valko
Thanks, that looks like what I'm looking for!
OK, then this should do what you want.
=SUMIF(A2:A5,">="&TODAY()-180,B2:B5)
Adjust the ranges to suit.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks