I have an Excel Spreadsheet and I am trying to summerise 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