excel question

If the name of a person falls within the days of 10/16/2022 and 1/21/2023, then do an xlookup to count how much the name of the person sold tvs. but once their name goes out of the range of 1/21/2023, then dont count.

this formual would apply to various names. As in, then the next persons dates would be different, but they would still need to be within a date range, and if their name falls out of it then dont count anymore