Formula dosnt work beed help. Basically, what i want the formula to do is:

If the name of the person, falls between two date ranges, then do an xlookup based on a pivot table based on the name, to count how much the name of the person sold.

for reference of the formula:

On the current tab im in (coms)

Column D has their orgin date.

Column E has the end date.

Column F has the names.

the dates tab(column j)

column j of the dates tab has the dates that are being counted within the xlookup.(so if a product was sold in the date column j of the dates tab, then the name of the person would only be counted if that date is between column D and E of the currenr tab im in)

comma F:F is the names of the people of the current tab im in.

count of product A:A is the pivot table. A is the names

count of product B:B is the count of products each person made.