Counting items for differnt sales groups by length of time.

I need to know per sales group how many items have been in inventory for 30, 60, 90, 120, 365+ days.

I have attached a file with a summary at bottom, I need to populate.

Any help is appreciated......

Hi
would a Pivot Table help ? ( see attached - Sheet 4)

Looks like i wouldbe perfect, but one thing I count figure out is how you got it sub divided by 1-29, 30-58, etc....Not a super pro.

Originally Posted by JonkerBonnkers

Looks like i wouldbe perfect, but one thing I count figure out is how you got it sub divided by 1-29, 30-58, etc....Not a super pro.

I used a Pivot table to get that result.
When the Table is created, right-click the field and select "group"
Just follow the wizard

HTH