Summing/Ageing of transactions into buckets

[pauldaddyadams]

Hi,

I have a report and I would like to age the transactions based on todays date and the posting date (column B on the sheet “Transactions” into the following categories:
0-30
30-60
60-90
90+

What is the formula to do this but that would also match the GL in column C on the “Bsheet tab” with column D)

[Special-K]

in E5
=SUMPRODUCT((Transactions!$D$5:$D$11=$C5)*(TODAY()-Transactions!$B$5:$B$11>=0)*(TODAY()-Transactions!$B$5:$B$11<=30)*(Transactions!$H$5:$H$11))
in F5
=SUMPRODUCT((Transactions!$D$5:$D$11=$C5)*(TODAY()-Transactions!$B$5:$B$11>=31)*(TODAY()-Transactions!$B$5:$B$11<=60)*(Transactions!$H$5:$H$11))
in G5
=SUMPRODUCT((Transactions!$D$5:$D$11=$C5)*(TODAY()-Transactions!$B$5:$B$11>=61)*(TODAY()-Transactions!$B$5:$B$11<=90)*(Transactions!$H$5:$H$11))
in H5
=SUMPRODUCT((Transactions!$D$5:$D$11=$C5)*(TODAY()-Transactions!$B$5:$B$11>=91)*(Transactions!$H$5:$H$11))

[pauldaddyadams]

Thanks Special-K! This worked brilliantly