Spreadsheet: 83926d1283962626-formula-to-condense-products
Sheet: Products

 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  | 13 |  |  |  |  |  |  |  | 14 |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  | 17
 | Product (1) |  |  |  |  | Payments  Product (1) |  |  | Product (2) |  |  |  |  | Payments  Product (2) |  |  | Product (3) |  |  |  |  | Payments  Product (3) |  |  | Product (4) |  |  |  |  | Payments  Product (4) |  |  | Product (5) |  |  |  |  | Payments  Product (5) |  |  | Product (6) |  |  |  |  | Payments  Product (6) |  |  | Product (7) |  |  |  |  | Payments  Product (7) |  |  | Product (8) |  |  |  |  | Payments  Product (8) |  |  | Product (9) |  |  |  |  | Payments  Product (9) |  |  | Product (10) |  |  |  |  | Payments  Product (10) |  |  | Product (11) |  |  |  |  | Payments  Product (11) |  |  | Product (12) |  |  |  |  | Payments  Product (12) |  |  | Product (13) |  |  |  |  | Payments  Product (13) |  |  | Product (14) |  |  |  |  | Payments  Product (14) |  |  | Product (15) |  |  |  |  | Payments  Product (15) |  |  | Product (16) |  |  |  |  | Payments  Product (16) |  |  | Product (17) |  |  |  |  | Payments  Product (17) |  |  | Total Paid for All Products |  | Total Cost of All Products
Client
NO. | Product (1) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (2) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (3) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (4) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (5) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (6) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (7) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (8) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (9) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (10) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (11) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (12) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (13) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (14) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (15) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (16) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Product (17) | Color | Code | Qty. | Unit Cost | Pymt Made | Pymt Date |  | Total PAID |  | Total COST
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEED CONDENSED FORMULA HERE