On time Delivery Performance by Year

Good Morning All


Looking for a little help with the following. I would like to write a subtotal formula with a countif function, but not sure where to start.

I have a range of data with a due date in column "D", delivery date in column "F" days taken for delivery which is a plus or minus value in column "G" and text value of either "On Time, "Late", "Early" in column "H" which is calculated on column G using the following: "=IF(G18>=1,"LATE",IF(G18=0,"ON TIME","EARLY")).

I then have a series of Countif formula to sum the total of each delivery condition i.e On Time, Late, Early which give a total Year to date count of each delivery condition.
is there a way to write a formula that A enables me to count the different deliveries conditions by year.
or alternatively a countif formula with a subtotal so that I can filter by data by year to produce the yearly delivery performance.


Thanks In advance

Mark

Hi msexcelathone

thanks for your prompt reply. could i be extremely cheeky and ask for an example of a formula.

Best Regards

Mark

Hi

Please see attached work book

Hi

Yes that is correct the formula's should sum. please except my apologies I changed the dates to 2015 in column C they should of been changed in column "F" "Delivery Date" but results should be.

On time Late Early
2015 3 2 0
2014 2 3 1


Best regards

Mark

Column F please

Correct sample attached