Another sub total question
On Nov 9, 4:36*pm, Mike H wrote:
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.- Hide quoted text -
- Show quoted text -
That does it! thanks that will save me some time in future
Martin
|