Thanx! That helps me some. however, I'm now looking for a way to be able to
do the same thing, but capture the values when they're in a certain row. For
example, I'd like to capture the number of cells with values between 1-100 in
any row in which AUGUST appears.

Help!
srain

"Barb Reinhardt" wrote:

Let's say the cells you are checking are A1:A100 and you want the count of
cells 1 and < 100.

=SUMPRODUCT(--(A1:A1001),--(A1:A100<100))
--
HTH,
Barb Reinhardt



"srain001" wrote:

How do I create a formula which can tell me how many cells fall between a
certain value? For example, I need a formula which lets me know how many
cells in a column have a value between 1-100, 100-200, 200-300, and so on.

Any help would be appreciated.

Thanx
srain