Aged Debt - grouping values by date range

D

DanCappagh

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.
 
B

Bob Phillips

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)
 
S

Stephen

Try a formula along these lines:
=SUMPRODUCT(--(B1:B100>X1),--(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.
 
Top