Hi,

Put this in d2 and drag down

=IF(A2<A3,SUM($C$2:C2)-SUM($D$1:D1),"")

Mike

" wrote:

Thakns for the response Mike but I don't think I made my self clear,
this is a production log sheet so is added to every day. I need to be
able to look back and see the number of components completed by each
shift on different days so need a total for ABC on each date

A B C D
Shift Part No Qty shift total
a 123 23
a 23 45
a 21 13 81
b 323 45
b 23 23 68
c 1 47
c 323 23
c 23
c 232 25 118
a 23 13
a 2323 15 28
b 23 35
b 23 23
b 23 14 72
etc. etc.