This should get the core desired Aging buckets-counts going for you

Assume source data in Sheet1,
col A = Business areas, eg: xx, yy, etc
col D = Dates (these are presumed real dates)

In your summary sheet,
In A2 down are listed the unique business areas, eg: xx, yy, etc

Enter the nums: 180, 360, 720 into B1:D1
Enter a label into E1: 720
B1:E1 will be the equivalent col headers for your:
0-6 months, 6-12 months, 12-24 months, 24+months
(assume 1 month = 30 days)

Place
In B2:
=SUMPRODUCT((Sheet1!$A$2:$A$10=$A2)*(TODAY()-Sheet1!$D$2:$D$10<=B$1))

In C2:
=SUMPRODUCT((Sheet1!$A$2:$A$10=$A2)*(TODAY()-Sheet1!$D$2:$D$10B$1)*(TODAY()-Sheet1!$D$2:$D$10<=C$1))
Copy C2 to D2

In E2:
=SUMPRODUCT((Sheet1!$A$2:$A$10=$A2)*(TODAY()-Sheet1!$D$2:$D$10D$1))

Select B2:E2, copy down. Adapt the ranges to suit your actuals.
Put in the right/bottom row/col totals as desired.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Chris waller" wrote:
I have an Excel Spreadsheet and I am trying to summarize some of the data in
a table. I don't know which formula to use and I would not know how to go
about creating such a formula. I only need to look at the rows where column A
is different to column B. I need to use a date that appears in column D and
to calculate between that date and the current date whatever that may be and
put the count/sum of the occurences in the correct cell on the summary table
as below.

Business Area 0-6 months 6-12 months 12-24 months 24+months Total
UG7 TDA UG6 1 1
SEO TDA UG7
HEO TDA SEO
EO TDA HEO 2 2
AO TDA EO 1 1
AA TDA AO 1 1
Total 1 1 3 1 5