Hi,

To count the numbers in a range

=SUMPRODUCT((C1:C100=200)*(C1:C100<=1000))

and your second question. Put this in C6 and drag down
=B6/$I$4

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Hoov" wrote:

I have two different questions.

First, I need to know what function to enter to determine how many
quantities of a particular item exist on a spreadsheet. For example, if I
wanted to know how many number existed in C1-C100 that were within the range
of $$200-$1000, how would I enter that function. Logically, it might be

=QTY((C1:C100)=200, <=1000) But, I need to know what it actually should be!

Also, I need to know how to keep one cell a constant in a function that i am
repeating. For example, the function that I want in C5 is "=B5/I4". Well,
in C6 i want B6/I4, and in C7 i need it to be B7/I4. So, I4 will be in every
equation, but B will change as I go down the spreadsheet. How can I get this
to automatically repeat over 200 cells or so?

Thanks so much, I greatly appreciate it!