====Items to Order==== ^ ~~=label(items_1)~~ Item ^ Part # ^ Description ^ Unit ^ Quan ^ Cost ^ Total ^ Comment/Notes ^ | ~~=cell(0,row()-1)+1~~ | NT855-G6 LONG | Cummins NT855-G6, CPL 1381 Reman Long Block | ea | 1 | 15500.00 | ~~=round((cell(4,row())*cell(5,row())),2)~~ | | | **//Total://** ^ $~~=round(sum(items_1.c5r1:c5r99),2)~~ ^ | Total should be $15500.00|| ====Items to Order==== ^ ~~=label(items_2)~~ Item ^ Part # ^ Description ^ Unit ^ Quan ^ Cost ^ Total ^ Comment/Notes ^ | ~~=cell(0,row()-1)+1~~ | NT855-G6 LONG | Cummins NT855-G6, CPL 1381 Reman Long Block | ea | 1 | 15500.00 | ~~=round((cell(4,row())*cell(5,row())),2)~~ | | | ~~=cell(0,row()-1)+1~~ | CORE | Block Core charge | ea | 1 | 4000.00 | ~~=round((cell(4,row())*cell(5,row())),2)~~ | | | ~~=cell(0,row()-1)+1~~ | LTL | Freight | ea | 1 | 1420.00 | ~~=round((cell(4,row())*cell(5,row())),2)~~ | | | ~~=cell(0,row()-1)+1~~ | TAX | Sales Tax | ea | 0 | 0 | ~~=round((cell(4,row())*cell(5,row())),2)~~ | | | **Total:** ||||| $ ~~=round(sum(c5r1:c5r3),2)~~ || | | **//Total://** | $ ~~=round(sum(items_2.c5r1:c5r3),2)~~ | | Total should be $20920.00 || See https://forum.dokuwiki.org/d/20026-tablecalc-stops-sum-after-too-many-entries/