Excel, Need some help
 

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

Hi!

One way:

=COUNTIF(A1:A10,"=1")-COUNTIF(A1:A10,"3")

Biff

"Niagera College Student"
wrote in message ...
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

"Biff" wrote:

Hi!

One way:

=COUNTIF(A1:A10,"=1")-COUNTIF(A1:A10,"3")

Biff

"Niagera College Student"
wrote in message ...
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