Spreadsheet: 709443d1608306263-return-value-based-on-multiple-row-occurrences-scratchingmyheadupdated
Sheet: Sales Receipts

Customer | Trans ID | Sales Receipt No | Sales Receipt Date | Deposit Date | Payment Method | Reference No | Deposit To | Memo | Product/Service 1 | Product/Service Amount 1 | Product/Service Class 1 | Product Service Taxable
Customer 1 | jEDVkqWlezbzqZPc2NPUI8nQch4F | [NAME] | 2020-12-14 00:00:00 | 2020-12-16 00:00:00 | Square |  | 12000 Undeposited Funds | Magazine | Magazine Sales - Tax | 10 | 13 Journal
Customer 1 | jEDVkqWlezbzqZPc2NPUI8nQch4F | [NAME] | 2020-12-14 00:00:00 | 2020-12-16 00:00:00 | Square |  | 12000 Undeposited Funds | Magazine | Magazine Sales - Tax | 10 | 13 Journal
Customer 1 | jEDVkqWlezbzqZPc2NPUI8nQch4F | [NAME] | 2020-12-14 00:00:00 | 2020-12-16 00:00:00 | Square |  | 12000 Undeposited Funds | Magazine | Magazine Sales - Tax | 10 | 13 Journal
Customer 1 | jEDVkqWlezbzqZPc2NPUI8nQch4F | [NAME] | 2020-12-14 00:00:00 | 2020-12-16 00:00:00 | Square |  | 12000 Undeposited Funds | Magazine | Magazine Sales - Tax | 10 | 13 Journal
Customer 1 | jEDVkqWlezbzqZPc2NPUI8nQch4F | [NAME] | 2020-12-14 00:00:00 | 2020-12-16 00:00:00 | Square |  | 12000 Undeposited Funds | Class | Language Class | 10 | 11 Classes
Customer 1 | jEDVkqWlezbzqZPc2NPUI8nQch4F | [NAME] | 2020-12-14 00:00:00 | 2020-12-16 00:00:00 | Square |  | 12000 Undeposited Funds | Magazine | Magazine Sales - Tax | 12 | 13 Journal
Customer 1 | jEDVkqWlezbzqZPc2NPUI8nQch4F | [NAME] | 2020-12-14 00:00:00 | 2020-12-16 00:00:00 | Square |  | 12000 Undeposited Funds | Magazine | Magazine Sales - Tax | 12 | 13 Journal
Customer 1 | jEDVkqWlezbzqZPc2NPUI8nQch4F | [NAME] | 2020-12-14 00:00:00 | 2020-12-16 00:00:00 | Square |  | 12000 Undeposited Funds | Magazine | Magazine Sales - Tax | 12 | 13 Journal
Customer 1 | jEDVkqWlezbzqZPc2NPUI8nQch4F | [NAME] | 2020-12-14 00:00:00 | 2020-12-16 00:00:00 | Square |  | 12000 Undeposited Funds | Shipping | Shipping Income | 3 | 13 Journal
Customer 2 | [NAME] | LKWEl6J5RJSO5wN7KAUm | 2020-12-13 00:00:00 | 2020-12-15 00:00:00 | Square |  | 12000 Undeposited Funds | Magazine | Magazine Sales - Non Tax | 12 | 13 Journal
Customer 2 | [NAME] | LKWEl6J5RJSO5wN7KAUm | 2020-12-13 00:00:00 | 2020-12-15 00:00:00 | Square |  | 12000 Undeposited Funds | Shipping | Shipping Income | 3 | 13 Journal
Customer 3 | buEURK8M31WOYkG65Emrxogbwe4F | buEURK8M31WOYkG65Emr | 2020-12-13 00:00:00 | 2020-12-15 00:00:00 | Square |  | 12000 Undeposited Funds | Subscription | Subscription | 35 | 13 Journal
Customer 3 | buEURK8M31WOYkG65Emrxogbwe4F | buEURK8M31WOYkG65Emr | 2020-12-13 00:00:00 | 2020-12-15 00:00:00 | Square |  | 12000 Undeposited Funds | Shipping | Shipping Income | 3 | 13 Journal
Customer 4 | 3SdDXpRELlr5jS3xpPSSlbLYve4F | 3SdDXpRELlr5jS3xpPSS | 2020-12-12 00:00:00 | 2020-12-14 00:00:00 | Square |  | 12000 Undeposited Funds | Class | Language Class | 240 | 11 Classes
Customer 5 | tbMFeRWZAFH73SGwPTM2v86acd4F | tbMFeRWZAFH73SGwPTM2 | 2020-12-11 00:00:00 | 2020-12-14 00:00:00 | Square |  | 12000 Undeposited Funds | Subscription | Subscription | 20 | 13 Journal
Customer 5 | tbMFeRWZAFH73SGwPTM2v86acd4F | tbMFeRWZAFH73SGwPTM2 | 2020-12-11 00:00:00 | 2020-12-14 00:00:00 | Square |  | 12000 Undeposited Funds | Subscription | Shipping Income | 3 | 13 Journal
Customer 6 | Nno8Yagoq69txR3nhU5O2Za1bf4F | Nno8Yagoq69txR3nhU5O | 2020-12-10 00:00:00 | 2020-12-12 00:00:00 | Square |  | 12000 Undeposited Funds | Class | Language Class | 240 | 11 Classes
Customer 7 | FbQMjLhqGeVKh5qlTGDaleTHQh4F | FbQMjLhqGeVKh5qlTGDa | 2020-12-10 00:00:00 | 2020-12-12 00:00:00 | Square |  | 12000 Undeposited Funds | Class | Language Class | 240 | 11 Classes
Customer 8 | jI30Pk7agExz2tNvJiu0QMGD0f4F | jI30Pk7agExz2tNvJiu0 | 2020-12-10 00:00:00 | 2020-12-12 00:00:00 | Square |  | 12000 Undeposited Funds | Class | Language Class | 240 | 11 Classes
Customer 9 | [NAME] | FLk4iJ6dKsh8dB44QHRW | 2020-12-10 00:00:00 | 2020-12-12 00:00:00 | Square |  | 12000 Undeposited Funds | Subscription | Magazine Sales - Tax | 35 | 13 Journal
Customer 9 | [NAME] | FLk4iJ6dKsh8dB44QHRW | 2020-12-10 00:00:00 | 2020-12-12 00:00:00 | Square |  | 12000 Undeposited Funds | Shipping | Shipping Income | 3 | 13 Journal
Customer 10 | rsnU3mqh80DXw6E89OjXQN7SRi4F | rsnU3mqh80DXw6E89OjX | 2020-12-09 00:00:00 | 2020-12-11 00:00:00 | Square |  | 12000 Undeposited Funds | Subscription | Subscription | 20 | 13 Journal
Customer 10 | rsnU3mqh80DXw6E89OjXQN7SRi4F | rsnU3mqh80DXw6E89OjX | 2020-12-09 00:00:00 | 2020-12-11 00:00:00 | Square |  | 12000 Undeposited Funds | Shipping | Shipping Income | 3 | 13 Journal
Customer 1 | jEDVkqWlezbzqZPc2NPUI8nQch4F | [NAME] | 2020-12-14 00:00:00 | 2020-12-16 00:00:00 | Square |  | 12000 Undeposited Funds | Square Fees | Square Fees | -3.07
Customer 2 | [NAME] | LKWEl6J5RJSO5wN7KAUm | 2020-12-13 00:00:00 | 2020-12-15 00:00:00 | Square |  | 12000 Undeposited Funds | Square Fees | Square Fees | -0.74
Customer 3 | buEURK8M31WOYkG65Emrxogbwe4F | buEURK8M31WOYkG65Emr | 2020-12-13 00:00:00 | 2020-12-15 00:00:00 | Square |  | 12001 Undeposited Funds | Square Fees | Square Fees | -1.4
Customer 4 | 3SdDXpRELlr5jS3xpPSSlbLYve4F | 3SdDXpRELlr5jS3xpPSS | 2020-12-13 00:00:00 | 2020-12-15 00:00:00 | Square |  | 12000 Undeposited Funds | Square Fees | Square Fees | -7.26
Customer 5 | tbMFeRWZAFH73SGwPTM2v86acd4F | tbMFeRWZAFH73SGwPTM2 | 2020-12-12 00:00:00 | 2020-12-14 00:00:00 | Square |  | 12000 Undeposited Funds | Square Fees | Square Fees | -0.97
Customer 6 | Nno8Yagoq69txR3nhU5O2Za1bf4F | Nno8Yagoq69txR3nhU5O | 2020-12-11 00:00:00 | 2020-12-14 00:00:00 | Square |  | 12000 Undeposited Funds | Square Fees | Square Fees | -7.26
Customer 7 | FbQMjLhqGeVKh5qlTGDaleTHQh4F | FbQMjLhqGeVKh5qlTGDa | 2020-12-10 00:00:00 | 2020-12-12 00:00:00 | Square |  | 12000 Undeposited Funds | Square Fees | Square Fees | -7.26
Customer 8 | jI30Pk7agExz2tNvJiu0QMGD0f4F | jI30Pk7agExz2tNvJiu0 | 2020-12-10 00:00:00 | 2020-12-12 00:00:00 | Square |  | 12000 Undeposited Funds | Square Fees | Square Fees | -7.26
Customer 9 | [NAME] | FLk4iJ6dKsh8dB44QHRW | 2020-12-10 00:00:00 | 2020-12-12 00:00:00 | Square |  | 12000 Undeposited Funds | Square Fees | Square Fees | -1.48
Customer 10 | rsnU3mqh80DXw6E89OjXQN7SRi4F | rsnU3mqh80DXw6E89OjX | 2020-12-10 00:00:00 | 2020-12-12 00:00:00 | Square |  | 12000 Undeposited Funds | Square Fees | Square Fees | -0.97