How to fulfill the condition?

Question

excel

Hello, there is a plate of 10 products (name, price, quantity, amount)
How to calculate according to the condition: the
number of items sold at a price lower than the average;

Answer 1

Through "pivot tables" (aka "pivot tables").