Spreadsheet: 776670d1649854489-automatically-copy-data-into-summary-summary-example-raul-
Sheet: Sheet1

 |  | [NAME] range |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary
 |  | Date | Name |  |  |  |  | Score |  |  |  |  | Chit |  |  |  |  |  | Shift | Date | Chit | Score
 |  |  | [NAME] | Here are details that are irrelevant to the |  |  |  |  | All other cell content can be ignored
 |  |  | [NAME] | summary. Only C5, D5, I5 and N5 go |  |  |  |  |  |  |  |  |  | Data is entered daily into the detail
 |  | 2021-01-04 00:00:00 | [NAME] | into the summary. |  |  |  | 2614.75 |  |  |  |  | 1 | range, left.
 |  |  | [NAME] | Here are details that are irrelevant to the |  |  |  |  |  |  |  |  |  | How to automatically add new cell
 |  |  | [NAME] | summary. Only C9, D9, I9 and N9 go |  |  |  |  |  |  |  |  |  | content from the detail range (left)
 |  |  | [NAME] | into the summary. |  |  |  |  |  |  |  |  |  | into the summary (right)?
 |  | 2021-12-12 00:00:00 | [NAME] |  |  |  |  | 1899.18 |  |  |  |  | 14
 |  |  | [NAME]
 |  | 2021-12-18 00:00:00 | [NAME] |  |  |  |  | 1874.23 |  |  |  |  | 25
 |  |  | AAA | Here are details that are irrelevant to the |  |  |  |  | All other cell content can be ignored
 |  |  | AAA | summary. Only C5, D5, I5 and N5 go
 |  | 2022-01-05 00:00:00 | AAA | into the summary. |  |  |  | 2555.24 |  |  |  |  | 44
 |  |  | BBB | Here are details that are irrelevant to the
 |  |  | BBB | summary. Only C9, D9, I9 and N9 go
 |  |  | BBB | into the summary.
 |  | 2022-02-16 00:00:00 | BBB |  |  |  |  | 2167.76 |  |  |  |  | 49
 |  |  | CCC
 |  | 2022-03-08 00:00:00 | CCC |  |  |  |  | 2350.48 |  |  |  |  | 67
 |  | Date | Name |  |  |  |  | Score |  |  |  |  | Chit |  |  |  |  | Name | Shift | Date | Chit | Score
 |  |  | [NAME] | Here are details that are irrelevant to the |  |  |  |  | All other cell content can be ignored
 |  |  | [NAME] | summary. Only C5, D5, I5 and N5 go
 |  | 2021-01-04 00:00:00 | [NAME] | into the summary. |  |  |  | 2614.75 |  |  |  |  | 1
 |  |  | [NAME] | Here are details that are irrelevant to the
 |  |  | [NAME] | summary. Only C9, D9, I9 and N9 go
 |  |  | [NAME] | into the summary.
 |  | 2021-12-12 00:00:00 | [NAME] |  |  |  |  | 1899.18 |  |  |  |  | 14
 |  |  | [NAME]
 |  | 2021-12-18 00:00:00 | [NAME] |  |  |  |  | 1874.23 |  |  |  |  | 25
 |  |  | AAA | Here are details that are irrelevant to the |  |  |  |  | All other cell content can be ignored
 |  |  | AAA | summary. Only C5, D5, I5 and N5 go
 |  | 2022-01-05 00:00:00 | AAA | into the summary. |  |  |  | 2555.24 |  |  |  |  | 44
 |  |  | BBB | Here are details that are irrelevant to the
 |  |  | BBB | summary. Only C9, D9, I9 and N9 go
 |  |  | BBB | into the summary.
 |  | 2022-02-16 00:00:00 | BBB |  |  |  |  | 2167.76 |  |  |  |  | 49
 |  |  | CCC
 |  | 2022-03-08 00:00:00 | CCC |  |  |  |  | 2350.48 |  |  |  |  | 67
re 1: You could put that piece that returns 3 in each cell formula instead but that just makes the formulas longer. Effectively,
the IF-Formula on reaching the fourth entry, just returns "" and doesn't even bother evaluating the other leg (the FALSE part).
Or try this formula instead (without the IF-bit), and you'll see what happens from entry 4 onwards:
=INDEX($D$25:$D$42,MATCH(0,COUNTIF(S$24:S24,$D$25:$D$42),)).   So I just control for the error values (and the zero).
 |  | C  D  I  N | 25-42
re 2: Since the Date/Chit/Score values do not appear at the first instance of an occurrence but at the last one, you need to control
for that and shift accordingly. Again, this could have been brought all in-cell but would result in longer formulas that calculate more
than necessary.