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!