Thread
:
Need rolling summary of data
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Need rolling summary of data
something like this where c1 & d1 contain your desired dates
=sumproduct((month(a2:a22)=c1-2)*(month(a2:a22)<=d1-2)*b2:b22)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Pierre" wrote in message
oups.com...
Have data on a spreadsheet:
Shipdate Quantity
The data goes back 5 years, and is constantly updated with new
shipments being added.
Would like to have on another sheet a rolling summary of how many have
been shipped within the last 12 months, the previous 12 months to
that, etc, up to 5 years.
So the summary would look something like this:
Present to 12-Mos. 29
13-24 Mos. 55
25-36 Mos. 36
37-48 Mos. 55
49-60 Mos 39
TIA for any ideas on this.
Pierre
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett