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.

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.

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.