COUNT() MULTIPLE CONDITION

((count(Select(Product[Scan],(count(Select(Product[Item],IN([Item],{“Red”}),Date([Date])=[_THISROW].[Date])))))))

Ples help me, how to solve this formula. I want to count multiple condition in Appsheet.

What are the conditions? What are examples of the data?