Weekly Totals Based on Dates
 

Hi Everybody,

I keep a table that tracks an item with columns of dates when milestones are
met. I want to be able to generate a report each week that totals events that
happened during the previous week. The table I keep looks something like this:

Property Units Type Proposed Contracted Released
ABC 200 New 06/22/08 06/24/08 06/28/08
DEF 150 Used 06/01/08 06/27/08 07/28/08
GHI 300 New 06/25/08 07/25/08 08/01/08

I want a report that shows for the week ending 06/28/08, looks like this:

New Used Proposed Contracted Released
500 150 650 650 200

Suggestions and formulas are greatly appreciated.
--
JerryS

Weekly Totals Based on Dates
 

Hi JerryS,

Suggest you use a pivot table. See my online tutorial at
http://edferrero.com/ExcelTutorials/...4/Default.aspx

Ed Ferrero
www.edferrero.com

Hi Everybody,

I keep a table that tracks an item with columns of dates when milestones
are
met. I want to be able to generate a report each week that totals events
that
happened during the previous week. The table I keep looks something like
this:

Property Units Type Proposed Contracted Released
ABC 200 New 06/22/08 06/24/08 06/28/08
DEF 150 Used 06/01/08 06/27/08 07/28/08
GHI 300 New 06/25/08 07/25/08 08/01/08

I want a report that shows for the week ending 06/28/08, looks like this:

New Used Proposed Contracted Released
500 150 650 650 200

Suggestions and formulas are greatly appreciated.
--
JerryS