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