Grouping amounts based on working days

Hello,

I have a challenge that I need some help with:

I have a spreadsheet which lists the open invoices with due date and number of working days overdue

From this sheet I would like to sum invoice amount by group of overdue working days

For example:

Company..................0-30.............31-60
A.......................20.000..........100.000

Perhaps alternatively in my datasheet I should do the grouping but I also haven't find out how to do this.

This might look something like this:


A : Company
B : Invoice no
C : Invoice amount
D : Invoice overdue
E : Current date =today()
F : Number of working days overdue
G : 0-30
H : 31-60
I : 61-90

Where I would need formulas in the fields G H or I to put the sales amount in the correct column based on the number of working days overdue

I have added an example of what I am working on

Originally Posted by DonkeyOte

This post has an uncanny resemblance to: http://www.mrexcel.com/forum/showthread.php?t=498988

Yes I know , :-)

I am sorry for the cross post.

I have tried the grouping in the pivot table which works really nice but does not give me the groups that I want (or better what management wants)

I have a minimum of 0 and a maximum of 120 and now have the following groups

<0 = OK
0-29
30-59
60-89

etc
When I try the interval of 31 I get numbers which are also not correct

What should I do to get intervals like required:

0-30
31-60
61-90
91-120
>120

Perfect !

This did the trick

Many thanks for your help.
You helped my fix my problem