Spreadsheet: 780511d1652504416-sum-values-that-pertain-to-unique-values-in-seperate-column-sample-data
Sheet: Sample Data

itm_supplier_iid | qty_purchased | unit_price | disc_amount | total_amount | item_cost  EX | item_cost |  | item_margin | itm_title | item_description | user_id | cash_amount | card_type1_amount | card_type2_amount | card_type3_amount | cheque_amount | account_amount | invoice_no | invoice_date | change_given | compute_0024 | compute_0025 | compute_0026 | invoice_ln_no | customer_id | compute_0029 | [NAME] | compute_0031
XXXXX | 1 | 2800 | XXXXX | 2800 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217426 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 3 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | -1 | 950 | XXXXX | -950 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217426 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 1 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | 1 | 0 | XXXXX | 0 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217426 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 4 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | -1 | 50 | XXXXX | -50 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217426 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 2 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | -1 | 2000 | XXXXX | -2000 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217650 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 5 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | -1 | 1600 | XXXXX | -1600 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217650 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 3 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | -1 | 100 | XXXXX | -100 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217650 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 9 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | 1 | 3899 | XXXXX | 3000 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217650 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 4 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | -1 | 50 | XXXXX | -50 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217650 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 6 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | 1 | 2000 | XXXXX | 2000 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217651 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 1 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | -1 | 100 | XXXXX | -100 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217650 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 1 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | -1 | 0 | XXXXX | 0 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217651 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 3 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | -1 | 50 | XXXXX | -50 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217650 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 8 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | -1 | 275 | XXXXX | -275 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217650 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 2 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | -1 | 50 | XXXXX | -50 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217650 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 7 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | -1 | 2000 | XXXXX | -2000 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217651 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 2 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | 1 | 0 | XXXXX | 0 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217303 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 2 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | 1 | 0 | XXXXX | 0 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217303 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 1 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | 1 | 299 | XXXXX | 299 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217363 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 1 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | 1 | 179 | XXXXX | 179 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217363 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 2 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | 1 | 15 | XXXXX | 15 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217560 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 2 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | 1 | 20.99 | XXXXX | 20.99 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217560 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 3 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | 1 | 18.1 | XXXXX | 18.1 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217560 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 4 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | 1 | 539 | XXXXX | 539 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217560 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 1 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | -1 | 1450 | XXXXX | -1450 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217409 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 1 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | -1 | 0 | XXXXX | 0 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217409 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 3 | XXXXX | XXXXX | XXXXX | XXXXX
XXXXX | -1 | 1900 | XXXXX | -1900 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 217409 | XXXXX | XXXXX | XXXXX | XXXXX | XXXXX | 2 | XXXXX | XXXXX | XXXXX | XXXXX