Today is May 25, 2005

Column A has invoice numbers: 11233 , 11234 , 11235 , 11236
Column B has invoices dates: 3/24/05 , 2/24/05 , 1/24/05 ,
12/24/04
Column C has invoice amounts: $100.00, $200.00 , $300.00 , $400.00

Row 120 has titles: 31 - 60 , 61 - 90 , 91 - 120 , 120+

Row 121 totals: $100.00 , $200.00, $300.00 , $400.00


Row 121 has totals based on the invoice date and the age of the invoice
in reference to todays' date.

What I want to achieve is that if Column B has a date (s) that is 31 -
60 days older then todays' date, the corresponding amount (s) in column
C will be added together and the total would appear in Row 121 under the
31 - 60 title. And so on with the 61-90, 91-120 and 120+.

This is hard to explain, I hope this helps. Thanks - Kimberly


--
KimberlyL
------------------------------------------------------------------------
KimberlyL's Profile: http://www.excelforum.com/member.php...o&userid=23682
View this thread: http://www.excelforum.com/showthread...hreadid=373548