Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aged Debt - grouping values by date range
I have a range of values with corresponding dates. I want to group and total
values by date range. Effectively I'm trying to produce an aged debt summary. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aged Debt - grouping values by date range
Could you not just sort them then use subtotal?
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "DanCappagh" wrote in message ... I have a range of values with corresponding dates. I want to group and total values by date range. Effectively I'm trying to produce an aged debt summary. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Aged Debt - grouping values by date range
Try a formula along these lines:
=SUMPRODUCT(--(B1:B100X1),--(B1:B100<=Y1),A1:A100) where A1:A100 are your values, B1:B100 are the corresponding dates, X1 is the start date and Y1 the finish date. "DanCappagh" wrote in message ... I have a range of values with corresponding dates. I want to group and total values by date range. Effectively I'm trying to produce an aged debt summary. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique values from date range | Excel Discussion (Misc queries) | |||
Sum values within a specified date range | Excel Worksheet Functions | |||
Summary of values from a date range | Excel Worksheet Functions | |||
Need to know percapita consumer debt. Debt amount is 2121.1 bill. | Excel Discussion (Misc queries) | |||
Counting values within a Date Range | Excel Discussion (Misc queries) |