Spreadsheet: 56056d1256183649-sum-of-values-over-multiple-columns-sum-of-mulitple-columns-example
Sheet: Stock

 | Enter Cust. Inv # | 500
 | Output Total Cost | 490
Item 1 |  |  | Item 2 |  |  | Item 3 |  |  | Item 4 |  |  | Item 5 |  |  | Item 6
Purc. # | Cost | Cust.Inv # | Purc. # | Cost | Cust.Inv # | Purc. # | Cost | Cust.Inv # | Purc. # | Cost | Cust.Inv # | Purc. # | Cost | Cust.Inv # | Purc. # | Cost | Cust.Inv #
89001 | 10 | 100 | 89010 | 22 | 100 | 89041 | 28 | 100 | 89040 | 104 | 100 | 89039 | 109 | 100 | 89039 | 7 | 100
89001 | 10 | 100 | 89010 | 22 | 100 | 89041 | 28 | 100 | 89040 | 104 | 100 | 89039 | 109 | 100 | 89039 | 7 | 100
89001 | 10 | 100 | 89010 | 22 | 100 | 89041 | 28 | 100 | 89040 | 104 | 100 | 89039 | 109 | 100 | 89039 | 7 | 100
89001 | 10 | 100 | 89010 | 22 | 100 | 89041 | 28 | 100 | 89040 | 104 | 100 | 89039 | 109 | 100 | 89039 | 7 | 100
89001 | 10 | 100 | 89010 | 22 | 100 | 89041 | 28 | 100 | 89040 | 104 | 100 | 89039 | 109 | 100 | 89039 | 7 | 100
89001 | 10 | 200 | 89010 | 22 | 200 | 89041 | 28 | 200 | 89040 | 104 | 200 | 89039 | 109 | 200 | 89039 | 7 | 200
89001 | 10 | 200 | 89010 | 22 | 200 | 89041 | 28 | 200 | 89040 | 104 | 200 | 89039 | 109 | 200 | 89039 | 7 | 200
89001 | 10 | 200 | 89010 | 22 | 200 | 89041 | 28 | 200 | 89040 | 104 | 200 | 89039 | 109 | 200 | 89039 | 7 | 200
89001 | 10 | 200 | 89010 | 22 | 200 | 89041 | 28 | 200 | 89040 | 104 | 200 | 89039 | 109 | 200 | 89039 | 7 | 200
89001 | 10 | 200 | 89010 | 22 | 200 | 89041 | 28 | 200 | 89040 | 104 | 200 | 89039 | 109 | 200 | 89039 | 7 | 200
89001 | 10 | 200 | 89010 | 22 | 200 | 89041 | 28 | 200 | 89040 | 104 | 200 | 89039 | 109 | 200 | 89039 | 7 | 200
89001 | 10 | 200 | 89010 | 22 | 200 | 89041 | 28 | 200 | 89040 | 104 | 200 | 89039 | 109 | 200 | 89039 | 7 | 200
89001 | 10 | 200 | 89010 | 22 | 200 | 89041 | 28 | 200 | 89040 | 104 | 200 | 89039 | 109 | 200 | 89039 | 7 | 200
89001 | 10 | 200 | 89010 | 22 | 200 | 89041 | 28 | 200 | 89040 | 104 | 200 | 89039 | 109 | 200 | 89039 | 7 | 200
89001 | 10 | 200 | 89010 | 22 | 200 | 89041 | 28 | 200 | 89040 | 104 | 200 | 89039 | 109 | 200 | 89039 | 7 | 200
89001 | 10 | 300 | 89010 | 22 | 300 | 89041 | 28 | 300 | 89040 | 104 | 300 | 89039 | 109 | 300 | 89039 | 7 | 300
89001 | 10 | 300 | 89010 | 22 | 300 |  |  |  | 89040 | 104 | 300 | 89039 | 109 | 300 | 89039 | 7 | 300
89001 | 10 | 300 | 89010 | 22 | 300 |  |  |  | 89040 | 104 | 300 | 89039 | 109 | 300 | 89039 | 7 | 300
89001 | 10 | 300 | 89010 | 22 | 300 |  |  |  | 89040 | 104 | 300 | 89039 | 109 | 300 | 89039 | 7 | 300
89001 | 10 | 300 | 89010 | 22 | 300 |  |  |  | 89040 | 104 | 300 | 89039 | 109 | 300 | 89039 | 7 | 300
89001 | 10 | 400 | 89010 | 22 | 400 |  |  |  | 89040 | 104 | 400 | 89039 | 109 | 400 | 89039 | 7 | 400
89001 | 10 | 400 | 89010 | 22 | 400 |  |  |  | 89040 | 104 | 400 | 89039 | 109 | 400
89001 | 10 | 400 | 89010 | 22 | 400 |  |  |  | 89040 | 104 | 400 | 89039 | 109 | 400
89001 | 10 | 500 | 89010 | 22 | 500 |  |  |  | 89040 | 104 | 500 | 89039 | 109 | 500
89001 | 10 | 500 | 89010 | 22 | 500 |  |  |  | 89040 | 104 | 500 | 89039 | 109 | 500
 |  |  |  |  |  |  |  |  | 89040 | 104 | 100 | 89039 | 109 | 100
 |  |  |  |  |  |  |  |  | 89040 | 104 | 100 | 89039 | 109 | 100
 |  |  |  |  |  |  |  |  | 89040 | 104 | 100 | 89039 | 109 | 100
 |  |  |  |  |  |  |  |  | 89040 | 104 | 100 | 89039 | 109 | 100
 |  |  |  |  |  |  |  |  | 89040 | 104 | 100 | 89039 | 109 | 100
 |  |  |  |  |  |  |  |  | 89040 | 104 | 200 | 89039 | 109 | 200
 |  |  |  |  |  |  |  |  | 89040 | 104 | 200 | 89039 | 109 | 200
 |  |  |  |  |  |  |  |  | 89040 | 104 | 200 | 89039 | 109 | 200
 |  |  |  |  |  |  |  |  | 89040 | 104