# Summing/Ageing of transactions into buckets

1. ## Summing/Ageing of transactions into buckets

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)

2. ## Re: Summing/Ageing of transactions into buckets

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

3. ## Re: Summing/Ageing of transactions into buckets

Thanks Special-K! This worked brilliantly

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1