Spreadsheet: 708492d1607871817-using-text-in-one-cell-keep-a-running-total-in-another-of-the-amount-in-out-of-item-pth-test-inventory-v3-shareable
Sheet: F_In_Out Inventory

ID | Sheet | Cell | [NAME] | [NAME]
1 | In_Out Inventory | I3 | =IF(B3="","",SUM(H3*F3)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
2 | In_Out Inventory | J3 | =IF(E3="","",IF(AND(COUNTIF(E3:$E$3,"out")=COUNTIF($E$3:$E$54,"out"),E3="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(RC[-5]:R3C5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
3 | In_Out Inventory | K3 | [NAME]),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(RC[-6]:R3C5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
4 | In_Out Inventory | L3 | =IF(B3="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A3,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
5 | In_Out Inventory | M3 | =IF(B3="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
6 | In_Out Inventory | N3 | =IF(B3="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
7 | In_Out Inventory | I4 | =IF(B4="","",SUM(H4*F4)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
8 | In_Out Inventory | J4 | =IF(E4="","",IF(AND(COUNTIF(E$3:$E4,"out")=COUNTIF($E$3:$E$54,"out"),E4="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
9 | In_Out Inventory | K4 | =IF(E4="","",IF(AND(COUNTIF(E$3:$E4,"IN")=COUNTIF($E$3:$E$54,"IN"),E4="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
10 | In_Out Inventory | [NAME] | =IF(B4="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A4,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
11 | In_Out Inventory | M4 | =IF(B4="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
12 | In_Out Inventory | N4 | =IF(B4="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
13 | In_Out Inventory | I5 | =IF(B5="","",SUM(H5*F5)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
14 | In_Out Inventory | J5 | =IF(E5="","",IF(AND(COUNTIF(E$3:$E5,"out")=COUNTIF($E$3:$E$54,"out"),E5="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
15 | In_Out Inventory | K5 | =IF(E5="","",IF(AND(COUNTIF(E$3:$E5,"IN")=COUNTIF($E$3:$E$54,"IN"),E5="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
16 | In_Out Inventory | L5 | =IF(B5="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A5,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
17 | In_Out Inventory | M5 | =IF(B5="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
18 | In_Out Inventory | N5 | =IF(B5="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
19 | In_Out Inventory | I6 | =IF(B6="","",SUM(H6*F6)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
20 | In_Out Inventory | J6 | =IF(E6="","",IF(AND(COUNTIF(E$3:$E6,"out")=COUNTIF($E$3:$E$54,"out"),E6="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
21 | In_Out Inventory | K6 | =IF(E6="","",IF(AND(COUNTIF(E$3:$E6,"IN")=COUNTIF($E$3:$E$54,"IN"),E6="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
22 | In_Out Inventory | L6 | =IF(B6="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A6,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
23 | In_Out Inventory | M6 | =IF(B6="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
24 | In_Out Inventory | [NAME] | =IF(B6="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
25 | In_Out Inventory | I7 | =IF(B7="","",SUM(H7*F7)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
26 | In_Out Inventory | J7 | =IF(E7="","",IF(AND(COUNTIF(E$3:$E7,"out")=COUNTIF($E$3:$E$54,"out"),E7="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
27 | In_Out Inventory | K7 | =IF(E7="","",IF(AND(COUNTIF(E$3:$E7,"IN")=COUNTIF($E$3:$E$54,"IN"),E7="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
28 | In_Out Inventory | L7 | =IF(B7="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A7,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
29 | In_Out Inventory | M7 | =IF(B7="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
30 | In_Out Inventory | N7 | =IF(B7="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
31 | In_Out Inventory | I8 | =IF(B8="","",SUM(H8*F8)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
32 | In_Out Inventory | J8 | =IF(E8="","",IF(AND(COUNTIF(E$3:$E8,"out")=COUNTIF($E$3:$E$54,"out"),E8="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
33 | In_Out Inventory | K8 | =[NAME]),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
34 | In_Out Inventory | L8 | =IF(B8="","",SUM(SUMIFS([Amount],[Trans [NAME]})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
35 | In_Out Inventory | M8 | =IF(B8="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
36 | In_Out Inventory | N8 | =IF(B8="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
37 | In_Out Inventory | I9 | =IF(B9="","",SUM(H9*F9)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
38 | In_Out Inventory | J9 | =IF(E9="","",IF(AND(COUNTIF(E$3:$E9,"out")=COUNTIF($E$3:$E$54,"out"),E9="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
39 | In_Out Inventory | K9 | =[NAME]),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
40 | In_Out Inventory | L9 | =IF(B9="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A9,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
41 | In_Out Inventory | M9 | =IF(B9="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
42 | In_Out Inventory | N9 | =IF(B9="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
43 | In_Out Inventory | I10 | =IF(B10="","",SUM(H10*F10)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
44 | In_Out Inventory | J10 | =IF(E10="","",IF(AND(COUNTIF(E$3:$E10,"out")=COUNTIF($E$3:$E$54,"out"),E10="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
45 | In_Out Inventory | K10 | =IF(E10="","",IF(AND(COUNTIF(E$3:$E10,"IN")=COUNTIF($E$3:$E$54,"IN"),E10="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
46 | In_Out Inventory | L10 | =IF(B10="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A10,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
47 | In_Out Inventory | M10 | =IF(B10="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
48 | In_Out Inventory | N10 | =IF(B10="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
49 | In_Out Inventory | I11 | =IF(B11="","",SUM(H11*F11)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
50 | In_Out Inventory | J11 | =IF(E11="","",IF(AND(COUNTIF(E$3:$E11,"out")=COUNTIF($E$3:$E$54,"out"),E11="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
51 | In_Out Inventory | K11 | =IF(E11="","",IF(AND(COUNTIF(E$3:$E11,"IN")=COUNTIF($E$3:$E$54,"IN"),E11="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
52 | In_Out Inventory | L11 | =IF(B11="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A11,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
53 | In_Out Inventory | M11 | =IF(B11="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
54 | In_Out Inventory | N11 | =IF(B11="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
55 | In_Out Inventory | I12 | =IF(B12="","",SUM(H12*F12)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
56 | In_Out Inventory | J12 | =IF(E12="","",IF(AND(COUNTIF(E$3:$E12,"out")=COUNTIF($E$3:$E$54,"out"),E12="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
57 | In_Out Inventory | K12 | =IF(E12="","",IF(AND(COUNTIF(E$3:$E12,"IN")=COUNTIF($E$3:$E$54,"IN"),E12="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
58 | In_Out Inventory | L12 | =IF(B12="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A12,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
59 | In_Out Inventory | M12 | =IF(B12="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
60 | In_Out Inventory | N12 | =IF(B12="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
61 | In_Out Inventory | I13 | =IF(B13="","",SUM(H13*F13)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
62 | In_Out Inventory | J13 | =IF(E13="","",IF(AND(COUNTIF(E$3:$E13,"out")=COUNTIF($E$3:$E$54,"out"),E13="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
63 | In_Out Inventory | K13 | =IF(E13="","",IF(AND(COUNTIF(E$3:$E13,"IN")=COUNTIF($E$3:$E$54,"IN"),E13="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
64 | In_Out Inventory | [NAME] | =IF(B13="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A13,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
65 | In_Out Inventory | [NAME] | =IF(B13="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
66 | In_Out Inventory | N13 | =IF(B13="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
67 | In_Out Inventory | I14 | =IF(B14="","",SUM(H14*F14)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
68 | In_Out Inventory | J14 | =IF(E14="","",IF(AND(COUNTIF(E$3:$E14,"out")=COUNTIF($E$3:$E$54,"out"),E14="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
69 | In_Out Inventory | K14 | =IF(E14="","",IF(AND(COUNTIF(E$3:$E14,"IN")=COUNTIF($E$3:$E$54,"IN"),E14="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
70 | In_Out Inventory | [NAME] | =IF(B14="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A14,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
71 | In_Out Inventory | M14 | =IF(B14="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
72 | In_Out Inventory | [NAME] | =IF(B14="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
73 | In_Out Inventory | [NAME] | =IF(B15="","",SUM(H15*F15)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
74 | In_Out Inventory | J15 | =IF(E15="","",IF(AND(COUNTIF(E$3:$E15,"out")=COUNTIF($E$3:$E$54,"out"),E15="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
75 | In_Out Inventory | K15 | =IF(E15="","",IF(AND(COUNTIF(E$3:$E15,"IN")=COUNTIF($E$3:$E$54,"IN"),E15="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
76 | In_Out Inventory | L15 | =IF(B15="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A15,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
77 | In_Out Inventory | M15 | =IF(B15="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
78 | In_Out Inventory | N15 | =IF(B15="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
79 | In_Out Inventory | I16 | =IF(B16="","",SUM(H16*F16)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
80 | In_Out Inventory | J16 | =IF(E16="","",IF(AND(COUNTIF(E$3:$E16,"out")=COUNTIF($E$3:$E$54,"out"),E16="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
81 | In_Out Inventory | K16 | =IF(E16="","",IF(AND(COUNTIF(E$3:$E16,"IN")=COUNTIF($E$3:$E$54,"IN"),E16="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
82 | In_Out Inventory | L16 | =IF(B16="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A16,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
83 | In_Out Inventory | M16 | =IF(B16="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
84 | In_Out Inventory | N16 | =IF(B16="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
85 | In_Out Inventory | I17 | =IF(B17="","",SUM(H17*F17)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
86 | In_Out Inventory | [NAME] | =IF(E17="","",IF(AND(COUNTIF(E$3:$E17,"out")=COUNTIF($E$3:$E$54,"out"),E17="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
87 | In_Out Inventory | K17 | =IF(E17="","",IF(AND(COUNTIF(E$3:$E17,"IN")=COUNTIF($E$3:$E$54,"IN"),E17="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
88 | In_Out Inventory | L17 | =IF(B17="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A17,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
89 | In_Out Inventory | [NAME] | =IF(B17="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
90 | In_Out Inventory | N17 | =IF(B17="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
91 | In_Out Inventory | I18 | =IF(B18="","",SUM(H18*F18)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
92 | In_Out Inventory | J18 | =IF(E18="","",IF(AND(COUNTIF(E$3:$E18,"out")=COUNTIF($E$3:$E$54,"out"),E18="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
93 | In_Out Inventory | K18 | =IF(E18="","",IF(AND(COUNTIF(E$3:$E18,"IN")=COUNTIF($E$3:$E$54,"IN"),E18="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
94 | In_Out Inventory | L18 | =IF(B18="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A18,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
95 | In_Out Inventory | M18 | =IF(B18="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
96 | In_Out Inventory | N18 | =IF(B18="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
97 | In_Out Inventory | I19 | =IF(B19="","",SUM(H19*F19)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
98 | In_Out Inventory | J19 | =IF(E19="","",IF(AND(COUNTIF(E$3:$E19,"out")=COUNTIF($E$3:$E$54,"out"),E19="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
99 | In_Out Inventory | K19 | =IF(E19="","",IF(AND(COUNTIF(E$3:$E19,"IN")=COUNTIF($E$3:$E$54,"IN"),E19="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
100 | In_Out Inventory | L19 | =IF(B19="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A19,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
101 | In_Out Inventory | M19 | =IF(B19="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
102 | In_Out Inventory | N19 | =IF(B19="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
103 | In_Out Inventory | I20 | =IF(B20="","",SUM(H20*F20)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
104 | In_Out Inventory | J20 | =IF(E20="","",IF(AND(COUNTIF(E$3:$E20,"out")=COUNTIF($E$3:$E$54,"out"),E20="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
105 | In_Out Inventory | K20 | =IF(E20="","",IF(AND(COUNTIF(E$3:$E20,"IN")=COUNTIF($E$3:$E$54,"IN"),E20="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
106 | In_Out Inventory | L20 | =IF(B20="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A20,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
107 | In_Out Inventory | M20 | =IF(B20="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
108 | In_Out Inventory | N20 | =IF(B20="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
109 | In_Out Inventory | I21 | =IF(B21="","",SUM(H21*F21)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
110 | In_Out Inventory | J21 | =[NAME]),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
111 | In_Out Inventory | K21 | =IF(E21="","",IF(AND(COUNTIF(E$3:$E21,"IN")=COUNTIF($E$3:$E$54,"IN"),E21="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
112 | In_Out Inventory | [NAME] | =IF(B21="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A21,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
113 | In_Out Inventory | M21 | =IF(B21="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
114 | In_Out Inventory | N21 | =IF(B21="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
115 | In_Out Inventory | I22 | =IF(B22="","",SUM(H22*F22)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
116 | In_Out Inventory | J22 | =IF(E22="","",IF(AND(COUNTIF(E$3:$E22,"out")=COUNTIF($E$3:$E$54,"out"),E22="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
117 | In_Out Inventory | K22 | =IF(E22="","",IF(AND(COUNTIF(E$3:$E22,"IN")=COUNTIF($E$3:$E$54,"IN"),E22="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
118 | In_Out Inventory | L22 | =IF(B22="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A22,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
119 | In_Out Inventory | M22 | =IF(B22="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
120 | In_Out Inventory | N22 | =IF(B22="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
121 | In_Out Inventory | I23 | =IF(B23="","",SUM(H23*F23)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
122 | In_Out Inventory | J23 | =IF(E23="","",IF(AND(COUNTIF(E$3:$E23,"out")=COUNTIF($E$3:$E$54,"out"),E23="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
123 | In_Out Inventory | K23 | =IF(E23="","",IF(AND(COUNTIF(E$3:$E23,"IN")=COUNTIF($E$3:$E$54,"IN"),E23="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
124 | In_Out Inventory | [NAME] | =IF(B23="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A23,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
125 | In_Out Inventory | M23 | =IF(B23="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
126 | In_Out Inventory | N23 | =IF(B23="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
127 | In_Out Inventory | I24 | =IF(B24="","",SUM(H24*F24)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
128 | In_Out Inventory | [NAME] | =[NAME]),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
129 | In_Out Inventory | K24 | =IF(E24="","",IF(AND(COUNTIF(E$3:$E24,"IN")=COUNTIF($E$3:$E$54,"IN"),E24="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
130 | In_Out Inventory | L24 | =IF(B24="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A24,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
131 | In_Out Inventory | M24 | =IF(B24="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
132 | In_Out Inventory | N24 | =IF(B24="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
133 | In_Out Inventory | I25 | =IF(B25="","",SUM(H25*F25)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
134 | In_Out Inventory | J25 | [NAME]),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
135 | In_Out Inventory | K25 | =IF(E25="","",IF(AND(COUNTIF(E$3:$E25,"IN")=COUNTIF($E$3:$E$54,"IN"),E25="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
136 | In_Out Inventory | [NAME] | =IF(B25="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A25,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
137 | In_Out Inventory | M25 | =IF(B25="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
138 | In_Out Inventory | N25 | =IF(B25="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
139 | In_Out Inventory | I26 | =IF(B26="","",SUM(H26*F26)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
140 | In_Out Inventory | J26 | =IF(E26="","",IF(AND(COUNTIF(E$3:$E26,"out")=COUNTIF($E$3:$E$54,"out"),E26="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
141 | In_Out Inventory | K26 | =IF(E26="","",IF(AND(COUNTIF(E$3:$E26,"IN")=COUNTIF($E$3:$E$54,"IN"),E26="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
142 | In_Out Inventory | L26 | =IF(B26="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A26,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
143 | In_Out Inventory | M26 | =IF(B26="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
144 | In_Out Inventory | N26 | =IF(B26="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
145 | In_Out Inventory | I27 | =IF(B27="","",SUM(H27*F27)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
146 | In_Out Inventory | J27 | =IF(E27="","",IF(AND(COUNTIF(E$3:$E27,"out")=COUNTIF($E$3:$E$54,"out"),E27="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
147 | In_Out Inventory | K27 | =IF(E27="","",IF(AND(COUNTIF(E$3:$E27,"IN")=COUNTIF($E$3:$E$54,"IN"),E27="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
148 | In_Out Inventory | L27 | =IF(B27="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A27,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
149 | In_Out Inventory | M27 | =IF(B27="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
150 | In_Out Inventory | N27 | =IF(B27="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
151 | In_Out Inventory | [NAME] | =IF(B28="","",SUM(H28*F28)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
152 | In_Out Inventory | J28 | =IF(E28="","",IF(AND(COUNTIF(E$3:$E28,"out")=COUNTIF($E$3:$E$54,"out"),E28="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
153 | In_Out Inventory | K28 | =[NAME]),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
154 | In_Out Inventory | L28 | =IF(B28="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A28,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
155 | In_Out Inventory | M28 | =IF(B28="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
156 | In_Out Inventory | N28 | =IF(B28="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
157 | In_Out Inventory | I29 | =IF(B29="","",SUM(H29*F29)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
158 | In_Out Inventory | J29 | =IF(E29="","",IF(AND(COUNTIF(E$3:$E29,"out")=COUNTIF($E$3:$E$54,"out"),E29="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
159 | In_Out Inventory | K29 | =IF(E29="","",IF(AND(COUNTIF(E$3:$E29,"IN")=COUNTIF($E$3:$E$54,"IN"),E29="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
160 | In_Out Inventory | L29 | =IF(B29="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A29,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
161 | In_Out Inventory | M29 | =IF(B29="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
162 | In_Out Inventory | N29 | =IF(B29="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
163 | In_Out Inventory | I30 | =IF(B30="","",SUM(H30*F30)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
164 | In_Out Inventory | J30 | =IF(E30="","",IF(AND(COUNTIF(E$3:$E30,"out")=COUNTIF($E$3:$E$54,"out"),E30="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
165 | In_Out Inventory | K30 | =[NAME]),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
166 | In_Out Inventory | L30 | =IF(B30="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A30,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
167 | In_Out Inventory | M30 | =IF(B30="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
168 | In_Out Inventory | N30 | =IF(B30="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
169 | In_Out Inventory | I31 | =IF(B31="","",SUM(H31*F31)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
170 | In_Out Inventory | J31 | [NAME]),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
171 | In_Out Inventory | K31 | =IF(E31="","",IF(AND(COUNTIF(E$3:$E31,"IN")=COUNTIF($E$3:$E$54,"IN"),E31="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
172 | In_Out Inventory | [NAME] | =IF(B31="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A31,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
173 | In_Out Inventory | M31 | =IF(B31="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
174 | In_Out Inventory | N31 | =IF(B31="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
175 | In_Out Inventory | I32 | =IF(B32="","",SUM(H32*F32)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
176 | In_Out Inventory | J32 | =IF(E32="","",IF(AND(COUNTIF(E$3:$E32,"out")=COUNTIF($E$3:$E$54,"out"),E32="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
177 | In_Out Inventory | [NAME] | =IF(E32="","",IF(AND(COUNTIF(E$3:$E32,"IN")=COUNTIF($E$3:$E$54,"IN"),E32="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
178 | In_Out Inventory | L32 | =IF(B32="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A32,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
179 | In_Out Inventory | M32 | =IF(B32="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
180 | In_Out Inventory | N32 | =IF(B32="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
181 | In_Out Inventory | I33 | =IF(B33="","",SUM(H33*F33)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
182 | In_Out Inventory | J33 | =IF(E33="","",IF(AND(COUNTIF(E$3:$E33,"out")=COUNTIF($E$3:$E$54,"out"),E33="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
183 | In_Out Inventory | K33 | =IF(E33="","",IF(AND(COUNTIF(E$3:$E33,"IN")=COUNTIF($E$3:$E$54,"IN"),E33="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
184 | In_Out Inventory | [NAME] | =IF(B33="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A33,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
185 | In_Out Inventory | M33 | =IF(B33="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
186 | In_Out Inventory | N33 | =IF(B33="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
187 | In_Out Inventory | I34 | =IF(B34="","",SUM(H34*F34)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
188 | In_Out Inventory | [NAME] | =IF(E34="","",IF(AND(COUNTIF(E$3:$E34,"out")=COUNTIF($E$3:$E$54,"out"),E34="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
189 | In_Out Inventory | K34 | =IF(E34="","",IF(AND(COUNTIF(E$3:$E34,"IN")=COUNTIF($E$3:$E$54,"IN"),E34="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
190 | In_Out Inventory | L34 | =IF(B34="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A34,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
191 | In_Out Inventory | M34 | =IF(B34="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
192 | In_Out Inventory | N34 | =IF(B34="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
193 | In_Out Inventory | I35 | =IF(B35="","",SUM(H35*F35)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
194 | In_Out Inventory | J35 | =IF(E35="","",IF(AND(COUNTIF(E$3:$E35,"out")=COUNTIF($E$3:$E$54,"out"),E35="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
195 | In_Out Inventory | [NAME] | =[NAME]),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
196 | In_Out Inventory | L35 | =IF(B35="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A35,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
197 | In_Out Inventory | M35 | =IF(B35="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
198 | In_Out Inventory | N35 | =IF(B35="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
199 | In_Out Inventory | I36 | =IF(B36="","",SUM(H36*F36)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
200 | In_Out Inventory | [NAME] | =IF(E36="","",IF(AND(COUNTIF(E$3:$E36,"out")=COUNTIF($E$3:$E$54,"out"),E36="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
201 | In_Out Inventory | K36 | =IF(E36="","",IF(AND(COUNTIF(E$3:$E36,"IN")=COUNTIF($E$3:$E$54,"IN"),E36="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
202 | In_Out Inventory | [NAME] | =IF(B36="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A36,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
203 | In_Out Inventory | M36 | =IF(B36="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
204 | In_Out Inventory | N36 | =IF(B36="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
205 | In_Out Inventory | I37 | =IF(B37="","",SUM(H37*F37)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
206 | In_Out Inventory | [NAME] | =IF(E37="","",IF(AND(COUNTIF(E$3:$E37,"out")=COUNTIF($E$3:$E$54,"out"),E37="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
207 | In_Out Inventory | [NAME] | =IF(E37="","",IF(AND(COUNTIF(E$3:$E37,"IN")=COUNTIF($E$3:$E$54,"IN"),E37="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
208 | In_Out Inventory | L37 | =IF(B37="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A37,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
209 | In_Out Inventory | M37 | =IF(B37="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
210 | In_Out Inventory | N37 | =IF(B37="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
211 | In_Out Inventory | I38 | =IF(B38="","",SUM(H38*F38)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
212 | In_Out Inventory | J38 | =IF(E38="","",IF(AND(COUNTIF(E$3:$E38,"out")=COUNTIF($E$3:$E$54,"out"),E38="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
213 | In_Out Inventory | [NAME] | =IF(E38="","",IF(AND(COUNTIF(E$3:$E38,"IN")=COUNTIF($E$3:$E$54,"IN"),E38="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
214 | In_Out Inventory | L38 | =IF(B38="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A38,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
215 | In_Out Inventory | M38 | =IF(B38="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
216 | In_Out Inventory | N38 | =IF(B38="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
217 | In_Out Inventory | I39 | =IF(B39="","",SUM(H39*F39)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
218 | In_Out Inventory | J39 | =IF(E39="","",IF(AND(COUNTIF(E$3:$E39,"out")=COUNTIF($E$3:$E$54,"out"),E39="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
219 | In_Out Inventory | K39 | =IF(E39="","",IF(AND(COUNTIF(E$3:$E39,"IN")=COUNTIF($E$3:$E$54,"IN"),E39="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
220 | In_Out Inventory | L39 | =IF(B39="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A39,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
221 | In_Out Inventory | M39 | =IF(B39="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
222 | In_Out Inventory | N39 | =IF(B39="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
223 | In_Out Inventory | I40 | =IF(B40="","",SUM(H40*F40)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
224 | In_Out Inventory | J40 | =IF(E40="","",IF(AND(COUNTIF(E$3:$E40,"out")=COUNTIF($E$3:$E$54,"out"),E40="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
225 | In_Out Inventory | K40 | =IF(E40="","",IF(AND(COUNTIF(E$3:$E40,"IN")=COUNTIF($E$3:$E$54,"IN"),E40="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
226 | In_Out Inventory | L40 | =IF(B40="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A40,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
227 | In_Out Inventory | M40 | =IF(B40="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
228 | In_Out Inventory | N40 | =IF(B40="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
229 | In_Out Inventory | I41 | =IF(B41="","",SUM(H41*F41)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
230 | In_Out Inventory | J41 | =IF(E41="","",IF(AND(COUNTIF(E$3:$E41,"out")=COUNTIF($E$3:$E$54,"out"),E41="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
231 | In_Out Inventory | K41 | =IF(E41="","",IF(AND(COUNTIF(E$3:$E41,"IN")=COUNTIF($E$3:$E$54,"IN"),E41="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
232 | In_Out Inventory | [NAME] | =IF(B41="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A41,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
233 | In_Out Inventory | M41 | =IF(B41="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
234 | In_Out Inventory | N41 | =IF(B41="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
235 | In_Out Inventory | I42 | =IF(B42="","",SUM(H42*F42)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
236 | In_Out Inventory | J42 | =IF(E42="","",IF(AND(COUNTIF(E$3:$E42,"out")=COUNTIF($E$3:$E$54,"out"),E42="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
237 | In_Out Inventory | K42 | =IF(E42="","",IF(AND(COUNTIF(E$3:$E42,"IN")=COUNTIF($E$3:$E$54,"IN"),E42="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
238 | In_Out Inventory | L42 | =IF(B42="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A42,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
239 | In_Out Inventory | M42 | =IF(B42="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
240 | In_Out Inventory | N42 | =IF(B42="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
241 | In_Out Inventory | I43 | =IF(B43="","",SUM(H43*F43)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
242 | In_Out Inventory | J43 | =IF(E43="","",IF(AND(COUNTIF(E$3:$E43,"out")=COUNTIF($E$3:$E$54,"out"),E43="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
243 | In_Out Inventory | K43 | =IF(E43="","",IF(AND(COUNTIF(E$3:$E43,"IN")=COUNTIF($E$3:$E$54,"IN"),E43="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
244 | In_Out Inventory | [NAME] | =IF(B43="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A43,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
245 | In_Out Inventory | M43 | =IF(B43="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
246 | In_Out Inventory | N43 | =IF(B43="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
247 | In_Out Inventory | I44 | =IF(B44="","",SUM(H44*F44)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
248 | In_Out Inventory | [NAME] | =IF(E44="","",IF(AND(COUNTIF(E$3:$E44,"out")=COUNTIF($E$3:$E$54,"out"),E44="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
249 | In_Out Inventory | K44 | =IF(E44="","",IF(AND(COUNTIF(E$3:$E44,"IN")=COUNTIF($E$3:$E$54,"IN"),E44="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
250 | In_Out Inventory | L44 | =IF(B44="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A44,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
251 | In_Out Inventory | M44 | =IF(B44="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
252 | In_Out Inventory | N44 | =IF(B44="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
253 | In_Out Inventory | I45 | =IF(B45="","",SUM(H45*F45)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
254 | In_Out Inventory | [NAME] | =IF(E45="","",IF(AND(COUNTIF(E$3:$E45,"out")=COUNTIF($E$3:$E$54,"out"),E45="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
255 | In_Out Inventory | K45 | =IF(E45="","",IF(AND(COUNTIF(E$3:$E45,"IN")=COUNTIF($E$3:$E$54,"IN"),E45="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
256 | In_Out Inventory | L45 | =IF(B45="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A45,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
257 | In_Out Inventory | M45 | =IF(B45="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
258 | In_Out Inventory | N45 | =IF(B45="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
259 | In_Out Inventory | I46 | =IF(B46="","",SUM(H46*F46)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
260 | In_Out Inventory | J46 | =IF(E46="","",IF(AND(COUNTIF(E$3:$E46,"out")=COUNTIF($E$3:$E$54,"out"),E46="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
261 | In_Out Inventory | K46 | =IF(E46="","",IF(AND(COUNTIF(E$3:$E46,"IN")=COUNTIF($E$3:$E$54,"IN"),E46="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
262 | In_Out Inventory | L46 | =IF(B46="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A46,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
263 | In_Out Inventory | M46 | =IF(B46="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
264 | In_Out Inventory | N46 | =IF(B46="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
265 | In_Out Inventory | [NAME] | =IF(B47="","",SUM(H47*F47)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
266 | In_Out Inventory | J47 | =IF(E47="","",IF(AND(COUNTIF(E$3:$E47,"out")=COUNTIF($E$3:$E$54,"out"),E47="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
267 | In_Out Inventory | K47 | =IF(E47="","",IF(AND(COUNTIF(E$3:$E47,"IN")=COUNTIF($E$3:$E$54,"IN"),E47="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
268 | In_Out Inventory | L47 | =IF(B47="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A47,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
269 | In_Out Inventory | M47 | =IF(B47="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
270 | In_Out Inventory | N47 | =IF(B47="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
271 | In_Out Inventory | I48 | =IF(B48="","",SUM(H48*F48)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
272 | In_Out Inventory | J48 | =IF(E48="","",IF(AND(COUNTIF(E$3:$E48,"out")=COUNTIF($E$3:$E$54,"out"),E48="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
273 | In_Out Inventory | K48 | =IF(E48="","",IF(AND(COUNTIF(E$3:$E48,"IN")=COUNTIF($E$3:$E$54,"IN"),E48="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
274 | In_Out Inventory | L48 | =IF(B48="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A48,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
275 | In_Out Inventory | M48 | =IF(B48="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
276 | In_Out Inventory | N48 | =IF(B48="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
277 | In_Out Inventory | I49 | =IF(B49="","",SUM(H49*F49)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
278 | In_Out Inventory | J49 | =IF(E49="","",IF(AND(COUNTIF(E$3:$E49,"out")=COUNTIF($E$3:$E$54,"out"),E49="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
279 | In_Out Inventory | K49 | =IF(E49="","",IF(AND(COUNTIF(E$3:$E49,"IN")=COUNTIF($E$3:$E$54,"IN"),E49="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
280 | In_Out Inventory | L49 | =IF(B49="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A49,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
281 | In_Out Inventory | M49 | =IF(B49="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
282 | In_Out Inventory | N49 | =IF(B49="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
283 | In_Out Inventory | [NAME] | =IF(B50="","",SUM(H50*F50)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
284 | In_Out Inventory | J50 | =IF(E50="","",IF(AND(COUNTIF(E$3:$E50,"out")=COUNTIF($E$3:$E$54,"out"),E50="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
285 | In_Out Inventory | K50 | [NAME]),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
286 | In_Out Inventory | L50 | =IF(B50="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A50,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
287 | In_Out Inventory | M50 | =IF(B50="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
288 | In_Out Inventory | N50 | =IF(B50="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
289 | In_Out Inventory | I51 | =IF(B51="","",SUM(H51*F51)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
290 | In_Out Inventory | J51 | =IF(E51="","",IF(AND(COUNTIF(E$3:$E51,"out")=COUNTIF($E$3:$E$54,"out"),E51="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
291 | In_Out Inventory | K51 | =IF(E51="","",IF(AND(COUNTIF(E$3:$E51,"IN")=COUNTIF($E$3:$E$54,"IN"),E51="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
292 | In_Out Inventory | L51 | =IF(B51="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A51,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
293 | In_Out Inventory | M51 | =IF(B51="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
294 | In_Out Inventory | N51 | =IF(B51="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
295 | In_Out Inventory | I52 | =IF(B52="","",SUM(H52*F52)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
296 | In_Out Inventory | J52 | =IF(E52="","",IF(AND(COUNTIF(E$3:$E52,"out")=COUNTIF($E$3:$E$54,"out"),E52="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
297 | In_Out Inventory | K52 | =IF(E52="","",IF(AND(COUNTIF(E$3:$E54,"IN")=COUNTIF($E$3:$E$54,"IN"),E52="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:R[2]C5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
298 | In_Out Inventory | L52 | =IF(B52="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A52,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
299 | In_Out Inventory | M52 | =IF(B52="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
300 | In_Out Inventory | N52 | =IF(B52="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
301 | In_Out Inventory | I53 | =IF(B53="","",SUM(H53*F53)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
302 | In_Out Inventory | J53 | =IF(E53="","",IF(AND(COUNTIF(E$3:$E53,"out")=COUNTIF($E$3:$E$54,"out"),E53="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
303 | In_Out Inventory | K53 | =IF(E53="","",IF(AND(COUNTIF(E$3:$E54,"IN")=COUNTIF($E$3:$E$54,"IN"),E53="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:R[1]C5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
304 | In_Out Inventory | L53 | =IF(B53="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A53,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
305 | In_Out Inventory | M53 | =IF(B53="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
306 | In_Out Inventory | N53 | =IF(B53="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
307 | In_Out Inventory | I54 | =IF(B54="","",SUM(H54*F54)) | =IF(RC[-7]="","",SUM(RC[-1]*RC[-3]))
308 | In_Out Inventory | J54 | =IF(E54="","",IF(AND(COUNTIF(E$3:$E54,"out")=COUNTIF($E$3:$E$54,"out"),E54="OUT"),SUMIF($E$3:$E$54,"OUT",$F$3:$F$54),"")) | =IF(RC[-5]="","",IF(AND(COUNTIF(R3C[-5]:RC5,"out")=COUNTIF(R3C5:R54C5,"out"),RC[-5]="OUT"),SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6),""))
309 | In_Out Inventory | K54 | =IF(E54="","",IF(AND(COUNTIF(E$3:$E54,"IN")=COUNTIF($E$3:$E$54,"IN"),E54="IN"),SUMIF($E$3:$E$54,"IN",$F$3:$F$54),"")) | =IF(RC[-6]="","",IF(AND(COUNTIF(R3C[-6]:RC5,"IN")=COUNTIF(R3C5:R54C5,"IN"),RC[-6]="IN"),SUMIF(R3C5:R54C5,"IN",R3C6:R54C6),""))
310 | In_Out Inventory | L54 | =IF(B54="","",SUM(SUMIFS([Amount],[Trans ID],"<="&A54,[In_Out],{"In","Out"})*{1,-1})) | =IF(RC[-10]="","",SUM(SUMIFS([Amount],[Trans ID],"<="&RC[-11],[In_Out],{"In","Out"})*{1,-1}))
311 | In_Out Inventory | M54 | =IF(B54="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-11]="","",(SUM(tblSales[[#Headers],[Amount]]:[@Amount])))
312 | In_Out Inventory | N54 | =IF(B54="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount]))) | =IF(RC[-12]="","",(SUM(tblSales[[#Headers],[Region]]:[@Region],[@Region],tblSales[[#Headers],[Amount]]:[@Amount])))
313 | In_Out Inventory | T3 | =IF([@[Tests Completed]]="","",SUM(S3*R3)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
314 | In_Out Inventory | U3 | =IF(P3="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
315 | In_Out Inventory | V3 | =IF(P3="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
316 | In_Out Inventory | W3 | =IF(P3="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
317 | In_Out Inventory | T4 | =IF([@[Tests Completed]]="","",SUM(S4*R4)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
318 | In_Out Inventory | U4 | =IF(P4="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
319 | In_Out Inventory | V4 | =IF(P4="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
320 | In_Out Inventory | W4 | =IF(P4="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
321 | In_Out Inventory | T5 | =IF([@[Tests Completed]]="","",SUM(S5*R5)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
322 | In_Out Inventory | U5 | =IF(P5="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
323 | In_Out Inventory | V5 | =IF(P5="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
324 | In_Out Inventory | W5 | =IF(P5="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
325 | In_Out Inventory | T6 | =IF([@[Tests Completed]]="","",SUM(S6*R6)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
326 | In_Out Inventory | U6 | =IF(P6="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
327 | In_Out Inventory | V6 | =IF(P6="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
328 | In_Out Inventory | W6 | =IF(P6="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
329 | In_Out Inventory | T7 | =IF([@[Tests Completed]]="","",SUM(S7*R7)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
330 | In_Out Inventory | U7 | =IF(P7="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
331 | In_Out Inventory | V7 | =IF(P7="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
332 | In_Out Inventory | W7 | =IF(P7="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
333 | In_Out Inventory | T8 | =IF([@[Tests Completed]]="","",SUM(S8*R8)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
334 | In_Out Inventory | U8 | =IF(P8="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
335 | In_Out Inventory | V8 | =IF(P8="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
336 | In_Out Inventory | W8 | =IF(P8="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
337 | In_Out Inventory | T9 | =IF([@[Tests Completed]]="","",SUM(S9*R9)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
338 | In_Out Inventory | U9 | =IF(P9="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
339 | In_Out Inventory | V9 | =IF(P9="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
340 | In_Out Inventory | W9 | =IF(P9="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
341 | In_Out Inventory | T10 | =IF([@[Tests Completed]]="","",SUM(S10*R10)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
342 | In_Out Inventory | U10 | =IF(P10="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
343 | In_Out Inventory | V10 | =IF(P10="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
344 | In_Out Inventory | W10 | =IF(P10="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
345 | In_Out Inventory | T11 | =IF([@[Tests Completed]]="","",SUM(S11*R11)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
346 | In_Out Inventory | U11 | =IF(P11="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
347 | In_Out Inventory | V11 | =IF(P11="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
348 | In_Out Inventory | W11 | =IF(P11="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
349 | In_Out Inventory | T12 | =IF([@[Tests Completed]]="","",SUM(S12*R12)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
350 | In_Out Inventory | U12 | =IF(P12="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
351 | In_Out Inventory | V12 | =IF(P12="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
352 | In_Out Inventory | W12 | =IF(P12="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
353 | In_Out Inventory | T13 | =IF([@[Tests Completed]]="","",SUM(S13*R13)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
354 | In_Out Inventory | U13 | =IF(P13="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
355 | In_Out Inventory | V13 | =IF(P13="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
356 | In_Out Inventory | W13 | =IF(P13="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
357 | In_Out Inventory | T14 | =IF([@[Tests Completed]]="","",SUM(S14*R14)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
358 | In_Out Inventory | U14 | =IF(P14="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
359 | In_Out Inventory | V14 | =IF(P14="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
360 | In_Out Inventory | W14 | =IF(P14="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
361 | In_Out Inventory | T15 | =IF([@[Tests Completed]]="","",SUM(S15*R15)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
362 | In_Out Inventory | U15 | =IF(P15="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
363 | In_Out Inventory | V15 | =IF(P15="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
364 | In_Out Inventory | W15 | =IF(P15="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
365 | In_Out Inventory | T16 | =IF([@[Tests Completed]]="","",SUM(S16*R16)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
366 | In_Out Inventory | U16 | =IF(P16="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
367 | In_Out Inventory | V16 | =IF(P16="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
368 | In_Out Inventory | W16 | =IF(P16="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
369 | In_Out Inventory | T17 | =IF([@[Tests Completed]]="","",SUM(S17*R17)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
370 | In_Out Inventory | U17 | =IF(P17="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
371 | In_Out Inventory | V17 | =IF(P17="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
372 | In_Out Inventory | W17 | =IF(P17="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
373 | In_Out Inventory | T18 | =IF([@[Tests Completed]]="","",SUM(S18*R18)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
374 | In_Out Inventory | U18 | =IF(P18="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
375 | In_Out Inventory | V18 | =IF(P18="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
376 | In_Out Inventory | W18 | =IF(P18="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
377 | In_Out Inventory | T19 | =IF([@[Tests Completed]]="","",SUM(S19*R19)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
378 | In_Out Inventory | U19 | =IF(P19="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
379 | In_Out Inventory | V19 | =IF(P19="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
380 | In_Out Inventory | W19 | =IF(P19="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
381 | In_Out Inventory | T20 | =IF([@[Tests Completed]]="","",SUM(S20*R20)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
382 | In_Out Inventory | U20 | =IF(P20="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
383 | In_Out Inventory | V20 | =IF(P20="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
384 | In_Out Inventory | W20 | =IF(P20="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
385 | In_Out Inventory | T21 | =IF([@[Tests Completed]]="","",SUM(S21*R21)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
386 | In_Out Inventory | U21 | =IF(P21="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
387 | In_Out Inventory | V21 | =IF(P21="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
388 | In_Out Inventory | W21 | =IF(P21="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
389 | In_Out Inventory | T22 | =IF([@[Tests Completed]]="","",SUM(S22*R22)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
390 | In_Out Inventory | U22 | =IF(P22="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
391 | In_Out Inventory | V22 | =IF(P22="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
392 | In_Out Inventory | [NAME] | =IF(P22="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
393 | In_Out Inventory | T23 | =IF([@[Tests Completed]]="","",SUM(S23*R23)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
394 | In_Out Inventory | U23 | =IF(P23="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
395 | In_Out Inventory | V23 | =IF(P23="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
396 | In_Out Inventory | W23 | =IF(P23="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
397 | In_Out Inventory | T24 | =IF([@[Tests Completed]]="","",SUM(S24*R24)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
398 | In_Out Inventory | U24 | =IF(P24="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
399 | In_Out Inventory | V24 | =IF(P24="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
400 | In_Out Inventory | W24 | =IF(P24="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
401 | In_Out Inventory | T25 | =IF([@[Tests Completed]]="","",SUM(S25*R25)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
402 | In_Out Inventory | U25 | =IF(P25="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
403 | In_Out Inventory | V25 | =IF(P25="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
404 | In_Out Inventory | W25 | =IF(P25="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
405 | In_Out Inventory | T26 | =IF([@[Tests Completed]]="","",SUM(S26*R26)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
406 | In_Out Inventory | U26 | =IF(P26="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
407 | In_Out Inventory | V26 | =IF(P26="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
408 | In_Out Inventory | W26 | =IF(P26="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
409 | In_Out Inventory | T27 | =IF([@[Tests Completed]]="","",SUM(S27*R27)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
410 | In_Out Inventory | U27 | =IF(P27="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
411 | In_Out Inventory | V27 | =IF(P27="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
412 | In_Out Inventory | [NAME] | =IF(P27="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
413 | In_Out Inventory | T28 | =IF([@[Tests Completed]]="","",SUM(S28*R28)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
414 | In_Out Inventory | U28 | =IF(P28="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
415 | In_Out Inventory | V28 | =IF(P28="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
416 | In_Out Inventory | W28 | =IF(P28="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
417 | In_Out Inventory | T29 | =IF([@[Tests Completed]]="","",SUM(S29*R29)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
418 | In_Out Inventory | U29 | =IF(P29="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
419 | In_Out Inventory | V29 | =IF(P29="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
420 | In_Out Inventory | W29 | =IF(P29="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
421 | In_Out Inventory | T30 | =IF([@[Tests Completed]]="","",SUM(S30*R30)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
422 | In_Out Inventory | U30 | =IF(P30="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
423 | In_Out Inventory | V30 | =IF(P30="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
424 | In_Out Inventory | W30 | =IF(P30="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
425 | In_Out Inventory | T31 | =IF([@[Tests Completed]]="","",SUM(S31*R31)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
426 | In_Out Inventory | U31 | =IF(P31="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
427 | In_Out Inventory | V31 | =IF(P31="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
428 | In_Out Inventory | W31 | =IF(P31="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
429 | In_Out Inventory | T32 | =IF([@[Tests Completed]]="","",SUM(S32*R32)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
430 | In_Out Inventory | U32 | =IF(P32="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
431 | In_Out Inventory | V32 | =IF(P32="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
432 | In_Out Inventory | W32 | =IF(P32="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
433 | In_Out Inventory | T33 | =IF([@[Tests Completed]]="","",SUM(S33*R33)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
434 | In_Out Inventory | U33 | =IF(P33="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
435 | In_Out Inventory | V33 | =IF(P33="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
436 | In_Out Inventory | W33 | =IF(P33="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
437 | In_Out Inventory | T34 | =IF([@[Tests Completed]]="","",SUM(S34*R34)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
438 | In_Out Inventory | U34 | =IF(P34="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
439 | In_Out Inventory | V34 | =IF(P34="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
440 | In_Out Inventory | [NAME] | =IF(P34="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
441 | In_Out Inventory | T35 | =IF([@[Tests Completed]]="","",SUM(S35*R35)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
442 | In_Out Inventory | U35 | =IF(P35="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
443 | In_Out Inventory | V35 | =IF(P35="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
444 | In_Out Inventory | W35 | =IF(P35="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
445 | In_Out Inventory | T36 | =IF([@[Tests Completed]]="","",SUM(S36*R36)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
446 | In_Out Inventory | U36 | =IF(P36="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
447 | In_Out Inventory | V36 | =IF(P36="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
448 | In_Out Inventory | W36 | =IF(P36="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
449 | In_Out Inventory | T37 | =IF([@[Tests Completed]]="","",SUM(S37*R37)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
450 | In_Out Inventory | U37 | =IF(P37="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
451 | In_Out Inventory | V37 | =IF(P37="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
452 | In_Out Inventory | W37 | =IF(P37="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
453 | In_Out Inventory | T38 | =IF([@[Tests Completed]]="","",SUM(S38*R38)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
454 | In_Out Inventory | U38 | =IF(P38="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
455 | In_Out Inventory | V38 | =IF(P38="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
456 | In_Out Inventory | W38 | =IF(P38="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
457 | In_Out Inventory | T39 | =IF([@[Tests Completed]]="","",SUM(S39*R39)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
458 | In_Out Inventory | U39 | =IF(P39="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
459 | In_Out Inventory | V39 | =IF(P39="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
460 | In_Out Inventory | W39 | =IF(P39="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
461 | In_Out Inventory | T40 | =IF([@[Tests Completed]]="","",SUM(S40*R40)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
462 | In_Out Inventory | U40 | =IF(P40="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
463 | In_Out Inventory | V40 | =IF(P40="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
464 | In_Out Inventory | W40 | =IF(P40="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
465 | In_Out Inventory | T41 | =IF([@[Tests Completed]]="","",SUM(S41*R41)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
466 | In_Out Inventory | U41 | =IF(P41="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
467 | In_Out Inventory | V41 | =IF(P41="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
468 | In_Out Inventory | W41 | =IF(P41="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
469 | In_Out Inventory | T42 | =IF([@[Tests Completed]]="","",SUM(S42*R42)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
470 | In_Out Inventory | U42 | =IF(P42="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
471 | In_Out Inventory | V42 | =IF(P42="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
472 | In_Out Inventory | W42 | =IF(P42="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
473 | In_Out Inventory | T43 | =IF([@[Tests Completed]]="","",SUM(S43*R43)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
474 | In_Out Inventory | U43 | =IF(P43="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
475 | In_Out Inventory | V43 | =IF(P43="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
476 | In_Out Inventory | W43 | =IF(P43="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
477 | In_Out Inventory | T44 | =IF([@[Tests Completed]]="","",SUM(S44*R44)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
478 | In_Out Inventory | U44 | =IF(P44="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
479 | In_Out Inventory | [NAME] | =IF(P44="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
480 | In_Out Inventory | W44 | =IF(P44="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
481 | In_Out Inventory | T45 | =IF([@[Tests Completed]]="","",SUM(S45*R45)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
482 | In_Out Inventory | U45 | =IF(P45="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
483 | In_Out Inventory | V45 | =IF(P45="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
484 | In_Out Inventory | W45 | =IF(P45="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
485 | In_Out Inventory | T46 | =IF([@[Tests Completed]]="","",SUM(S46*R46)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
486 | In_Out Inventory | U46 | =IF(P46="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
487 | In_Out Inventory | V46 | =IF(P46="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
488 | In_Out Inventory | W46 | =IF(P46="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
489 | In_Out Inventory | T47 | =IF([@[Tests Completed]]="","",SUM(S47*R47)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
490 | In_Out Inventory | U47 | =IF(P47="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
491 | In_Out Inventory | V47 | =IF(P47="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
492 | In_Out Inventory | W47 | =IF(P47="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
493 | In_Out Inventory | T48 | =IF([@[Tests Completed]]="","",SUM(S48*R48)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
494 | In_Out Inventory | U48 | =IF(P48="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
495 | In_Out Inventory | V48 | =IF(P48="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
496 | In_Out Inventory | [NAME] | =IF(P48="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
497 | In_Out Inventory | T49 | =IF([@[Tests Completed]]="","",SUM(S49*R49)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
498 | In_Out Inventory | U49 | =IF(P49="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
499 | In_Out Inventory | V49 | =IF(P49="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
500 | In_Out Inventory | [NAME] | =IF(P49="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
501 | In_Out Inventory | T50 | =IF([@[Tests Completed]]="","",SUM(S50*R50)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
502 | In_Out Inventory | U50 | =IF(P50="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
503 | In_Out Inventory | V50 | =IF(P50="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
504 | In_Out Inventory | W50 | =IF(P50="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
505 | In_Out Inventory | T51 | =IF([@[Tests Completed]]="","",SUM(S51*R51)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
506 | In_Out Inventory | U51 | =IF(P51="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
507 | In_Out Inventory | V51 | =IF(P51="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
508 | In_Out Inventory | W51 | =IF(P51="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
509 | In_Out Inventory | T52 | =IF([@[Tests Completed]]="","",SUM(S52*R52)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
510 | In_Out Inventory | U52 | =IF(P52="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
511 | In_Out Inventory | V52 | =IF(P52="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
512 | In_Out Inventory | W52 | =IF(P52="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
513 | In_Out Inventory | T53 | =IF([@[Tests Completed]]="","",SUM(S53*R53)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
514 | In_Out Inventory | U53 | =IF(P53="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
515 | In_Out Inventory | V53 | =IF(P53="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
516 | In_Out Inventory | W53 | =IF(P53="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
517 | In_Out Inventory | T54 | =IF([@[Tests Completed]]="","",SUM(S54*R54)) | =IF([@[Tests Completed]]="","",SUM(RC[-1]*RC[-2]))
518 | In_Out Inventory | U54 | =IF(P54="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-5]="","",(SUM(tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
519 | In_Out Inventory | V54 | =IF(P54="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-6]="","",(SUMIF(tblSales[[#Headers],[Region2]]:[@Region2],[@Region2],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
520 | In_Out Inventory | W54 | =IF(P54="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]]))) | =IF(RC[-7]="","",(SUMIF(tblSales[[#Headers],[Positive Confirmation Test]]:[@[Positive Confirmation Test]],[@[Positive Confirmation Test]],tblSales[[#Headers],[Confirmation Amount]]:[@[Confirmation Amount]])))
521 | In_Out Inventory | [NAME] | =IF(E3="","",SUMIF($E$3:$E$54,"IN",$F$3:$F$54)) | =IF(RC[-58]="","",SUMIF(R3C5:R54C5,"IN",R3C6:R54C6))
522 | In_Out Inventory | BK4 | =IF(E3="","",SUMIF($E$3:$E$54,"OUT",$F$3:$F$54)) | =IF(R[-1]C[-58]="","",SUMIF(R3C5:R54C5,"OUT",R3C6:R54C6))
523 | In_Out Inventory | BK17 | =SUMIF(E3:E54,"In",F3:F54) | =SUMIF(R[-14]C[-58]:R[37]C[-58],"In",R[-14]C[-57]:R[37]C[-57])
524 | In_Out Inventory | BK18 | =SUMIF(E3:E54,"Out",F3:F54) | =SUMIF(R[-15]C[-58]:R[36]C[-58],"Out",R[-15]C[-57]:R[36]C[-57])
525 | In_Out Inventory | BK19 | =BK17-BK18 | =R[-2]C-R[-1]C
526 | In_Out Inventory | BK22 | =SUMIF(G3:G54,"Hair Follicle",F3:F54) | =SUMIF(R[-19]C[-56]:R[32]C[-56],"Hair Follicle",R[-19]C[-57]:R[32]C[-57])
527 | In_Out Inventory | BK23 | =SUMIF(G3:G54,"Urine",F3:F54) | =SUMIF(R[-20]C[-56]:R[31]C[-56],"Urine",R[-20]C[-57]:R[31]C[-57])
528 | In_Out Inventory | BK24 | =SUMIF(G3:G54,"Oral",F3:F54) | =SUMIF(R[-21]C[-56]:R[30]C[-56],"Oral",R[-21]C[-57]:R[30]C[-57])
529 | In_Out Inventory | BO29 | =IF(B28="","",SUM(L$3:L28)) | =IF(R[-1]C[-65]="","",SUM(R3C[-55]:R[-1]C[-55]))
530 | In_Out Inventory | BO30 | =IF(B29="","",SUM(L$3:L29)) | =IF(R[-1]C[-65]="","",SUM(R3C[-55]:R[-1]C[-55]))
531 | In_Out Inventory | BO31 | =IF(B30="","",SUM(L$3:L30)) | =IF(R[-1]C[-65]="","",SUM(R3C[-55]:R[-1]C[-55]))
532 | In_Out Inventory | BO32 | =IF(B31="","",SUM(L$3:[NAME])) | =IF(R[-1]C[-65]="","",SUM(R3C[-55]:R[-1]C[-55]))
533 | In_Out Inventory | B3 | =IF([@[Trans ID]]<>"",IF(AND(B3<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B3,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
534 | In_Out Inventory | B4 | =IF([@[Trans ID]]<>"",IF(AND(B4<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B4,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
535 | In_Out Inventory | B5 | =IF([@[Trans ID]]<>"",IF(AND(B5<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B5,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
536 | In_Out Inventory | B6 | =IF([@[Trans ID]]<>"",IF(AND(B6<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B6,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
537 | In_Out Inventory | B7 | =IF([@[Trans ID]]<>"",IF(AND(B7<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B7,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
538 | In_Out Inventory | B8 | =IF([@[Trans ID]]<>"",IF(AND(B8<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B8,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
539 | In_Out Inventory | B9 | =IF([@[Trans ID]]<>"",IF(AND(B9<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B9,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
540 | In_Out Inventory | B10 | =IF([@[Trans ID]]<>"",IF(AND(B10<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B10,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
541 | In_Out Inventory | B11 | =IF([@[Trans ID]]<>"",IF(AND(B11<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B11,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
542 | In_Out Inventory | B12 | =IF([@[Trans ID]]<>"",IF(AND(B12<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B12,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
543 | In_Out Inventory | B13 | =IF([@[Trans ID]]<>"",IF(AND(B13<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B13,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
544 | In_Out Inventory | B14 | =IF([@[Trans ID]]<>"",IF(AND(B14<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B14,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
545 | In_Out Inventory | B15 | =IF([@[Trans ID]]<>"",IF(AND(B15<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B15,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
546 | In_Out Inventory | B16 | =IF([@[Trans ID]]<>"",IF(AND(B16<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B16,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
547 | In_Out Inventory | B17 | =IF([@[Trans ID]]<>"",IF(AND(B17<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B17,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
548 | In_Out Inventory | B18 | =IF([@[Trans ID]]<>"",IF(AND(B18<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B18,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
549 | In_Out Inventory | B19 | =IF([@[Trans ID]]<>"",IF(AND(B19<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B19,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
550 | In_Out Inventory | [NAME] | =IF([@[Trans ID]]<>"",IF(AND(B20<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B20,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
551 | In_Out Inventory | B21 | =IF([@[Trans ID]]<>"",IF(AND(B21<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B21,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
552 | In_Out Inventory | B22 | =IF([@[Trans ID]]<>"",IF(AND(B22<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B22,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
553 | In_Out Inventory | B23 | =IF([@[Trans ID]]<>"",IF(AND(B23<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B23,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
554 | In_Out Inventory | B24 | =IF([@[Trans ID]]<>"",IF(AND(B24<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B24,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
555 | In_Out Inventory | B25 | =IF([@[Trans ID]]<>"",IF(AND(B25<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B25,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
556 | In_Out Inventory | B26 | =IF([@[Trans ID]]<>"",IF(AND(B26<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B26,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
557 | In_Out Inventory | B27 | =IF([@[Trans ID]]<>"",IF(AND(B27<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B27,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
558 | In_Out Inventory | B28 | =IF([@[Trans ID]]<>"",IF(AND(B28<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B28,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
559 | In_Out Inventory | B29 | =IF([@[Trans ID]]<>"",IF(AND(B29<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B29,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
560 | In_Out Inventory | B30 | =IF([@[Trans ID]]<>"",IF(AND(B30<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B30,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
561 | In_Out Inventory | B31 | =IF([@[Trans ID]]<>"",IF(AND(B31<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B31,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
562 | In_Out Inventory | B32 | =IF([@[Trans ID]]<>"",IF(AND(B32<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B32,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
563 | In_Out Inventory | B33 | =IF([@[Trans ID]]<>"",IF(AND(B33<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B33,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
564 | In_Out Inventory | B34 | =IF([@[Trans ID]]<>"",IF(AND(B34<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B34,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
565 | In_Out Inventory | B35 | =IF([@[Trans ID]]<>"",IF(AND(B35<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B35,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
566 | In_Out Inventory | B36 | =IF([@[Trans ID]]<>"",IF(AND(B36<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B36,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
567 | In_Out Inventory | B37 | =IF([@[Trans ID]]<>"",IF(AND(B37<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B37,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
568 | In_Out Inventory | B38 | =IF([@[Trans ID]]<>"",IF(AND(B38<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B38,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
569 | In_Out Inventory | [NAME] | =IF([@[Trans ID]]<>"",IF(AND(B39<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B39,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
570 | In_Out Inventory | B40 | =IF([@[Trans ID]]<>"",IF(AND(B40<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B40,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
571 | In_Out Inventory | [NAME] | =IF([@[Trans ID]]<>"",IF(AND(B41<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B41,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
572 | In_Out Inventory | B42 | =IF([@[Trans ID]]<>"",IF(AND(B42<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B42,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
573 | In_Out Inventory | B43 | =IF([@[Trans ID]]<>"",IF(AND(B43<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B43,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
574 | In_Out Inventory | B44 | =IF([@[Trans ID]]<>"",IF(AND(B44<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B44,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
575 | In_Out Inventory | B45 | =IF([@[Trans ID]]<>"",IF(AND(B45<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B45,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
576 | In_Out Inventory | B46 | =IF([@[Trans ID]]<>"",IF(AND(B46<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B46,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
577 | In_Out Inventory | B47 | =IF([@[Trans ID]]<>"",IF(AND(B47<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B47,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
578 | In_Out Inventory | B48 | =IF([@[Trans ID]]<>"",IF(AND(B48<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B48,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
579 | In_Out Inventory | [NAME] | =IF([@[Trans ID]]<>"",IF(AND(B49<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B49,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
580 | In_Out Inventory | B50 | =IF([@[Trans ID]]<>"",IF(AND(B50<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B50,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
581 | In_Out Inventory | B51 | =IF([@[Trans ID]]<>"",IF(AND(B51<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B51,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
582 | In_Out Inventory | B52 | =IF([@[Trans ID]]<>"",IF(AND(B52<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B52,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
583 | In_Out Inventory | B53 | =IF([@[Trans ID]]<>"",IF(AND(B53<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B53,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
584 | In_Out Inventory | B54 | =IF([@[Trans ID]]<>"",IF(AND(B54<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),B54,NOW())),"") | =IF([@[Trans ID]]<>"",IF(AND(RC<>"",CELL("address")=ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]]))),NOW(),IF(CELL("address")<>ADDRESS(ROW([@[Trans ID]]),COLUMN([@[Trans ID]])),RC,NOW())),"")
585 | In_Out Inventory | P3 | =IF(B3="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
586 | In_Out Inventory | P4 | =IF(B4="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
587 | In_Out Inventory | P5 | =IF(B5="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
588 | In_Out Inventory | P6 | =IF(B6="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
589 | In_Out Inventory | P7 | =IF(B7="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
590 | In_Out Inventory | P8 | =IF(B8="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
591 | In_Out Inventory | P9 | =IF(B9="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
592 | In_Out Inventory | P10 | =IF(B10="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
593 | In_Out Inventory | P11 | =IF(B11="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
594 | In_Out Inventory | P12 | =IF(B12="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
595 | In_Out Inventory | P13 | =IF(B13="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
596 | In_Out Inventory | P14 | =IF(B14="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
597 | In_Out Inventory | P15 | =IF(B15="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
598 | In_Out Inventory | P16 | =IF(B16="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
599 | In_Out Inventory | P17 | =IF(B17="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
600 | In_Out Inventory | P18 | =IF(B18="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
601 | In_Out Inventory | P19 | =IF(B19="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
602 | In_Out Inventory | P20 | =IF(B20="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
603 | In_Out Inventory | P21 | =IF(B21="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
604 | In_Out Inventory | P22 | =IF(B22="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
605 | In_Out Inventory | P23 | =IF(B23="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
606 | In_Out Inventory | P24 | =IF(B24="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
607 | In_Out Inventory | P25 | =IF(B25="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
608 | In_Out Inventory | P26 | =IF(B26="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
609 | In_Out Inventory | P27 | =IF(B27="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
610 | In_Out Inventory | P28 | =IF(B28="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
611 | In_Out Inventory | P29 | =IF(B29="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
612 | In_Out Inventory | P30 | =IF(B30="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
613 | In_Out Inventory | P31 | =IF(B31="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
614 | In_Out Inventory | P32 | =IF(B32="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
615 | In_Out Inventory | P33 | =IF(B33="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
616 | In_Out Inventory | P34 | =IF(B34="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
617 | In_Out Inventory | P35 | =IF(B35="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
618 | In_Out Inventory | [NAME] | =IF(B36="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
619 | In_Out Inventory | P37 | =IF(B37="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
620 | In_Out Inventory | P38 | =IF(B38="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
621 | In_Out Inventory | P39 | =IF(B39="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
622 | In_Out Inventory | [NAME] | =IF(B40="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
623 | In_Out Inventory | P41 | =IF(B41="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
624 | In_Out Inventory | P42 | =IF(B42="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
625 | In_Out Inventory | P43 | =IF(B43="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
626 | In_Out Inventory | P44 | =IF(B44="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
627 | In_Out Inventory | P45 | =IF(B45="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
628 | In_Out Inventory | P46 | =IF(B46="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
629 | In_Out Inventory | P47 | =IF(B47="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
630 | In_Out Inventory | P48 | =IF(B48="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
631 | In_Out Inventory | P49 | =IF(B49="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
632 | In_Out Inventory | P50 | =IF(B50="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
633 | In_Out Inventory | [NAME] | =IF(B51="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
634 | In_Out Inventory | P52 | =IF(B52="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
635 | In_Out Inventory | P53 | =IF(B53="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
636 | In_Out Inventory | P54 | =IF(B54="","",([@Region])) | =IF(RC[-14]="","",([@Region]))
637 | In_Out Inventory | G65 | =SUMIF(tblSales[[#Headers],[In_Out]],F3,tblSales[Amount]) | =SUMIF(tblSales[[#Headers],[In_Out]],R[-62]C[-1],tblSales[Amount])