Excel, Need some help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thaks Biff I was able to use the frequency comand to do just what I needed.
Thank you for your time thought
 
Back
Top