View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kriss Kriss is offline
external usenet poster
 
Posts: 5
Default How many delayed per week

Item Contract Delivery Planned Delivery
a 2008-47 2008-48
b 2008-48 2008-48
c 2008-47 2008-47
b 2008-49 2008-50
a 2008-50 2008-50
b 2008-47 2008-50
c 2008-47 2008-47
b 2008-51 2008-51
a 2008-51 2008-51
a 2008-46 2008-49
c 2008-48 2008-48
b 2008-49 2008-51
a 2008-49 2008-49
c 2008-50 2008-50

Week Total Delayed per week
2008-46 Formula???
2008-47 Formula???
2008-48 Formula???
2008-49 Formula???
2008-50 Formula???
2008-51 Formula???

I've got this information. What formula can I use to display how many items
are delayed per week? I intend to use this information to make an overview
over delayed items and the progress on the backlog.

Hope anyone understand my question and can help me.