way around a summary list in excel to remove the negative

[Mokor]

i calculated receipts and issues of products using excel, i was required to summarise the products into cartons, rolls and pieces . to get the balance, i needed to subtract. but on the summary sheet, i am having negatives in some areas and would be grateful in anyone can help. im not so good in excel but im trying to develop myself as well. below is the summary and a product report of receipts and issues(IN and OUT) HELP.xlsx B C D E F 6 PRODUCT NAME CARTONS ROLLS PCS T/UNITS 7 8 9 1111 109 (12) (7) 13,001 10 2222 - 11 (4) 62 11 3333 - 2 (9) 15 12 4444 112 8 -2 13,518 13 5555 53.00 (7) 3 6,293 14 6666 108 (16) -2 12,798 15 7777 56.00 3.00 0 28 SUMMARY Cell Formulas Range Formula C9:E9 C9 ='1111'!F125-'1111'!J125 F9 F9 ='1111'!N125 C10:E10 C10 ='2222'!F125-'2222'!J125 F10 F10 ='2222'!N125 C11:E11 C11 ='3333'!F125-'3333'!J125 F11 F11 ='3333'!N125 C12:E12 C12 ='4444'!F125-'4444'!J125 F12 F12 ='4444'!N125 C13:E13 C13 ='5555'!F125-'5555'!J125 F13 F13 ='5555'!N125 C14:E14 C14 ='6666'!F125-'6666'!J125 F14 F14 ='6666'!N125 C15,E15 C15 ='7777'!F11-'7777'!J11 D15 D15 ='7777'!G125-'7777'!K125 F15 F15 ='7777'!N125

HELP.xlsx B C D E F G H I J K L M N 7 WAYBILL/ INVOICE NO. A ROLL A CTN UNITS/CTN CARTONS ROLLS PCS T/UNITS CARTONS ROLLS PCS T/UNITS CLOSING STOCK 8 9 PACK SIZE 10 BALANCE B/F 6 20 120 16.00 1 97 - 97 11 Clinic 7266 6 20 120 - 6 36 61 12 Transfer 2138 6 20 120 59 7,080 - 7,141 13 Transfer 2140 6 20 120 51 6,120 - 13,261 14 Transfer 1115 6 20 120 56 6,720 - 19,981 15 Mary 0006480 6 20 120 - 2 12 19,969 16 Transfer 2658 6 20 120 53 11 6,426 - 26,395 17 Clinic 0009526 6 20 120 - 3 18 26,377 18 Ibadan 0009709 6 20 120 - 10 1,200 25,177 19 Apapa 0009711 6 20 120 - 10 1,200 23,977 20 Kano 0009706 6 20 120 - 10 1,200 22,777 21 Jos 0009707 6 20 120 - 30 3,600 19,177 22 Sokoto 0009712 6 20 120 - 20 2,400 16,777 23 Kaduna 0009714 6 20 120 - 25 3,000 13,777 24 Abule-E 0009715 6 20 120 - 20 2,400 11,377 25 Akure 0009717 6 20 120 - 20 2,400 8,977 26 Sunday 2020084 6 20 120 - 4 480 8,497 27 Frm. Ibadan 6 20 120 10 1,200 - 9,697 28 Clinic 8301 6 20 120 - 5 30 9,667 29 PSN/S. 8338 6 20 120 - 5 30 9,637 30 NNPC % Kad. 8147 6 20 120 - 1 13 2 200 9,437 31 Aarcee 2020091 6 20 120 - 5 600 8,837 32 Aba 0010420 6 20 120 - 20 2,400 6,437 33 Sola 0010734 6 20 120 - 2 2 6,435 34 YODMA D20201219 6 20 120 - 41 10 4 4,984 1,451 35 Apapa 0009406 6 20 120 - 3 360 1,091 36 Transfer 2910 6 20 120 4 9 534 - 1,625 37 Promo-Team 6491 6 20 120 - 1 6 1,619 38 Clinic 0008422 6 20 120 - 3 18 1,601 39 Kano 0010445 6 20 120 - 10 1,200 401 40 Kaduna 0007501 6 20 120 - 3 360 41 41 Transfer 4119 6 20 120 48 5,760 - 5,801 42 Transfer 5224 6 20 120 60 7,200 - 13,001 1111 Cell Formulas Range Formula M10:M42 M10 =J10*E10+K10*C10+L10 N10:N42 N10 =N9+I10-M10 E10:E42 E10 =C10*D10 I10:I42 I10 =F10*E10+G10*C10+H10

 

[yky]

I can't work out the math. In the Summary sheet:

F9: 13001 = 109*120 - 12*6 - 7, OK
F10: 62 = 11*6 - 4, OK
F11: 15 = 2*6 - 9, ??????
F12: 13518 = 112*120 + 8*6 - 2 , ???????
F13: 6293 = 53*120 - 7*6 + 3, ????????
F14: 12798 = 108*120 - 16*6 - 2, ??????
F15: 28 = 56*120 + 3*6, ??????????