Spreadsheet: 797928d1664216501-trying-to-combine-product-prices-via-invoice-numbers-to-calculate-total-sale-2022-06-29-oeldere-bbop228294-excel_example_data
Sheet: Sheet1

Invoice # | Total Order $ | Product Price | Timestamp | Delivered Date | [NAME] | Person//First Name | Person//Last Name | Person//Address | Person//Address 2 | Person//City | Person//State | Person//Zip | Person//Phone | Person//Work Phone | Person//Email | Item | Item Description | Category | Store Location
11010490 |  | 997 | 2014-05-25 00:00:00 | 2014-05-25 00:00:00 | BETTY SUE | BETTY | SUE | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] |  | BED | Beautiful furniture | BDRM | 1
110100002 |  | 599 | 2016-12-12 00:00:00 | 2016-12-15 00:00:00 | HANK ROO | HANK | ROO | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | SOFA | Beautiful furniture | LVRM | 1
110100002 |  | 599 | 2016-12-12 00:00:00 | 2016-12-15 00:00:00 | HANK ROO | HANK | ROO | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | CHAISE | Beautiful furniture | LVRM | 1
110100002 |  | 199 | 2016-12-12 00:00:00 | 2016-12-15 00:00:00 | HANK ROO | HANK | ROO | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | WARRANTY | Beautiful furniture | WAR | 1
110100005 |  | 749 | 2016-12-12 00:00:00 | 2016-12-14 00:00:00 | TRINA BLACK | TRINA | BLACK | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | BED SET | Beautiful furniture | BDRM | 1
110100005 |  | 129 | 2016-12-12 00:00:00 | 2016-12-14 00:00:00 | TRINA BLACK | TRINA | BLACK | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | BED | Beautiful furniture | BDRM | 1
110100005 |  | 100 | 2016-12-12 00:00:00 | 2016-12-14 00:00:00 | TRINA BLACK | TRINA | BLACK | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | SOFA | Beautiful furniture | BDRM | 1
110100005 |  | 50 | 2016-12-12 00:00:00 | 2016-12-14 00:00:00 | TRINA BLACK | TRINA | BLACK | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | CHAISE | Beautiful furniture | BDRM | 1
110100005 |  | 319 | 2016-12-12 00:00:00 | 2016-12-14 00:00:00 | TRINA BLACK | TRINA | BLACK | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | WARRANTY | Beautiful furniture | BDRM | 1
110100005 |  | 79 | 2016-12-12 00:00:00 | 2016-12-14 00:00:00 | TRINA BLACK | TRINA | BLACK | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | BED SET | Beautiful furniture | BDRM | 1
110100005 |  | 129 | 2016-12-12 00:00:00 | 2016-12-14 00:00:00 | TRINA BLACK | TRINA | BLACK | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | BED | Beautiful furniture | BDRM | 1
110100005 |  | 449 | 2016-12-12 00:00:00 | 2016-12-14 00:00:00 | TRINA BLACK | TRINA | BLACK | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | SOFA | Beautiful furniture | BED | 1
110100005 |  | 199 | 2016-12-12 00:00:00 | 2016-12-14 00:00:00 | TRINA BLACK | TRINA | BLACK | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | CHAISE | Beautiful furniture | BED | 1
110100029 |  | 99 | 2016-12-12 00:00:00 | 2016-12-13 00:00:00 | [NAME] ICE | [NAME] | ICE | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | WARRANTY | Beautiful furniture | BDRM | 1
110100055 |  | 349 | 2016-12-12 00:00:00 | 2016-12-16 00:00:00 | [NAME] | [NAME] | ROCK | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | BED SET | Beautiful furniture | LVRM | 1
110100055 |  | 349 | 2016-12-12 00:00:00 | 2016-12-16 00:00:00 | [NAME] | [NAME] | ROCK | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | BED | Beautiful furniture | LVRM | 1
110100061 |  | 1199 | 2016-12-12 00:00:00 | 2016-12-17 00:00:00 | [NAME] | ALFRED | HITCHCOCK | 12345 [NAME] | APT. 1225 | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | SOFA | Beautiful furniture | LVRM | 1
110100061 |  | 199 | 2016-12-12 00:00:00 | 2016-12-17 00:00:00 | [NAME] | ALFRED | HITCHCOCK | 12345 [NAME] | APT. 1225 | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | CHAISE | Beautiful furniture | WAR | 1
110100065 |  | 1999 | 2016-12-12 00:00:00 | 2016-12-17 00:00:00 | [NAME] | RITA | HAYWORTH | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | WARRANTY | Beautiful furniture | LVRM | 1
110100065 |  | 1999 | 2016-12-12 00:00:00 | 2016-12-17 00:00:00 | [NAME] | RITA | HAYWORTH | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | BED SET | Beautiful furniture | LVRM | 1
110100065 |  | 1099 | 2016-12-12 00:00:00 | 2016-12-17 00:00:00 | [NAME] | RITA | HAYWORTH | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | BED | Beautiful furniture | LVRM | 1
110100065 |  | 199 | 2016-12-12 00:00:00 | 2016-12-17 00:00:00 | [NAME] | RITA | HAYWORTH | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | SOFA | Beautiful furniture | WAR | 1
110100066 |  | 399 | 2016-12-12 00:00:00 | 2016-12-20 00:00:00 | [NAME] | [NAME] | COOPER | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | CHAISE | Beautiful furniture | LVRM | 1
110100066 |  | 699 | 2016-12-12 00:00:00 | 2016-12-20 00:00:00 | [NAME] | [NAME] | COOPER | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | WARRANTY | Beautiful furniture | LVRM | 1
110100067 |  | 549 | 2016-12-12 00:00:00 | 2016-12-20 00:00:00 | BETTE DAVIS | BETTE | DAVIS | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | BED SET | Beautiful furniture | LVRM | 1
110100067 |  | 40 | 2016-12-12 00:00:00 | 2016-12-20 00:00:00 | BETTE DAVIS | BETTE | DAVIS | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | BED | Beautiful furniture | FEE | 1
110100067 |  | 299 | 2016-12-12 00:00:00 | 2016-12-20 00:00:00 | BETTE DAVIS | BETTE | DAVIS | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | SOFA | Beautiful furniture | BDRM | 1
110100067 |  | 99 | 2016-12-12 00:00:00 | 2016-12-20 00:00:00 | BETTE DAVIS | BETTE | DAVIS | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | CHAISE | Beautiful furniture | BDRM | 1
110100072 |  | 1349 | 2016-12-13 00:00:00 | 2016-12-13 00:00:00 | [NAME] | [NAME] | CRAWFORD | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | WARRANTY | Beautiful furniture | DNG | 1
110100072 |  | 1199 | 2016-12-13 00:00:00 | 2016-12-13 00:00:00 | [NAME] | [NAME] | CRAWFORD | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | BED SET | Beautiful furniture | DNG | 1
110100072 |  | 199 | 2016-12-13 00:00:00 | 2016-12-13 00:00:00 | [NAME] | [NAME] | CRAWFORD | 12345 [NAME] |  | SAN DIEGO | CA | 12315 | [PHONE] | [PHONE] | [EMAIL] | BED | Beautiful furniture | DNG | 1
Note - we want the product prices to be summed up for matching invoice #'s, and then that total number to be provided in a separate column (I have column B open for this right now, for example)