What formula should I set in a Google spreadsheet so that part of the data is transferred to another sheet using the date filter?

Question

Google Sheets

I have a table.

I can't figure out how to make the "customer account" sheet display data exactly for the selected date by filter (in a white box) and by last name.

It is necessary that there are rows category, columns for this date category, number of pieces, amount and total for all categories.

Answer 1

The right question is half the solution.

by filter

It remains to write in English and capital letters: FILTER .
Use two conditions in the function parameters: for the last name and for the date.