The easiest way is =SUMIF(...,<=X,...)-SUMIF(...,<=X-8,...)

Hope that makes sense.

Sam


"Kesbutler" wrote:

I am trying to sum the data for the previous week based on today's date.
The raw data is contained on one worksheet while i need the result on another.

I am using the SUMIF formula and am able to get data for a specific date or
all dates less than today or all dates greater than today.

Here is what I have: =(SUMIF('Weekly dates'!A1"AZ1,'<="&A5,Details!L7:N7))
I've tried using just = or using and I've tried to minus 7 but that gives
me just the data for the day 7 days previous. I need all the dates for the

Weekly dates is a spreadsheet with all the week ending dates
&A5 is the cell where the TODAY formula is located
Details!L7:N7 is the spreadsheet and cells that contain the data I need to
sum.

What is need is only the data in the previous week based on today's date.

Any ideas