Excel, Need some help

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
 
G

Guest

Thaks Biff I was able to use the frequency comand to do just what I needed.
Thank you for your time thought
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help creating a running subtotal 2
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
How to ignore a column of numbers in Grand Total for rows 1
What function to use? 6
Sum of different value in different worksheet & cell number 2
Retrieve Column Header for Specific Data in a Row 3
Need help in showing future purchases over a period of time and atset intervals 2
Will sumproduct work? 1

Top