Counting the number of instances

Hello Everybody

I am looking for a littel help completing a function on excel. I will explain the scenario to give a little background to the problem...

OK...I am making a report showing the delivery performance of suppliers. In excel at the moment I have a the following data -

Supplier
Order number
Requested delivery date
Actual delivery date
Number of days late or early (negative or positive number)

Some suppliers have multiple deliveries so multiple rows in excel.

I am looking for a function or functions that will count the number of late or early deliveries within certain parameters. The parameters are -

0 (days)
1 - 2 (days)
3-7 (days)
Over 7 (days)

So for each supplier I would generate a report showing -

Total number of deliveries
Total number of deliveries on time (0 days)
Total number of deliveries on 1-2 days late
Total number of deliveries on 3-7 days late
Total number of deliveries on over 7 days late

Could anyone help me or push me in the right direction? I understand this may need several calculations to achieve the desired results...

Thanks
Rhys

Hi Dom

I have attached the SS showing the data on one page and the report on the second page...

Thanks
Rhys

Thanks Dom - I apprecaite the help.

Can you reccomend any good resources to help learn how to use pivot tables...

You could also get all the required results by using the functions Sumif or Sumifs,I just added a small example of how they work in your workbook,hope that helps......

Thanks Dom

I have been trying to work through backwards what you have done to create the pivot table but just can't see it to work. (The computer is going through the window shortly :-)

You couldn't talk me through the steps to create that report could you please?

Thanks again
Rhys