Sorry John! I should have anticipated such a scenario. :) Try the
following formula instead...

=IF(E2<"",SUMPRODUCT(--(B2:B100=E2),--(C2:C100<""),--(MATCH(C2:C100&"",
C2:C100&"",0)<ROW(B2:B100)-ROW(B2)+1)),"")

Hope this helps!

In article ,
johncassell
wrote:

Thanks for that Domenic that was exactly what I was looking for, apart
from one thing which i forgot to mention, sorry! - There will be a lot
of jobs which don't have an order number yet (i.e blank cells) and I
would like to ignore these ones.

Your formula was far too clever for me so I couldn't work out how to
exclude blanks cells, is this easy to work into the formula?

Thanks for all your help

John