I am creating a distributioon table of data and would like to have exel count
how may time a number between a range apears.

for exsample  if I sell  100 apples  for diffrent prices i want a formula
that will calculate how many of them were sold for $1=<>3.

I do not want the sum of the price of apples I just want to know that I sold
10 apples whose price ranged between $1 and $3