I have attached a copy of a sheet I'm working in.
Sources
| Timestamp | Name | Scan | Date | Scan Total |
|---|---|---|---|---|
| 8/23/2022 4:57:38 | A | AM-Scan 1 | 8/23/2022 | 315 |
| 8/23/2022 5:09:26 | B | AM-Scan 1 | 8/23/2022 | 1161 |
| 8/23/2022 5:10:45 | C | AM-Scan 1 | 8/23/2022 | 89 |
| 8/23/2022 16:41:28 | D | AM-Scan 1 | 8/23/2022 | 1161 |
| 8/23/2022 21:37:09 | A | PM-Scan 2 | 8/23/2022 | 1260 |
| 8/23/2022 21:38:53 | B | PM-Scan 2 | 8/23/2022 | 315 |
| 8/23/2022 21:46:25 | C | PM-Scan 2 | 8/23/2022 | 945 |
| 8/23/2022 21:53:14 | D | PM-Scan 2 | 8/23/2022 | 630 |
Notes
If you want to delve deep, consider looking at the previous 
How to use
CodePudding user response：
This method combines your date match, scan match, and total column into one array formula.
=ArrayFormula(((D2:D=D3:D)*(D3:D=D4:D)*(D4:D=D5:D)*(C2:C=C3:C)*(C3:C=C4:C)*(C4:C=C5:C))*(E2:E E3:E E4:E E5:E))
Since you need Date Match to be true and Scan Match to be true, you can combine those two columns using the same multiplication method you've already used. Then you multiply that value (it will be 0 if false and 1 if true) by the sum of the current row and the next three rows in column E (like you've already done in the Overall Total column) to get the total. I've included the ISBLANK test to prevent 0s from populating the full length of the column.
