Charting a range of data

[Guest]

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

 

[Guest]

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

=SUMPRODUCT(--(A1:A100>1),--(A1:A100<100))

 

[Guest]

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

 

[Guest]

I probably won't be able to get back until tomorrow, but here are my questions:

1) What rows/columns might August be present?
2) What rows/Columns might the numbers be present?

Thanks,

Barb Reinhardt

 

[Guest]

1) AUGUST is present in Column A, as well as several rows within that column
2) the numbers are present in Column X, all rows.

 

[Guest]

I'm going to assume that you have August as a text string. If that's not
true, this may need modification

=SUMPRODUCT(--(A1:A100="August"),--(X1:X100>1),--(X1:X100<100))

 

[Guest]

For some reason ,it's not working. I keep getting a value of zero in the
cell, even though the columns are correct and there are values in the cells.
Here's what I'm inputting:
=SUMPRODUCT(--(Figures!A1:A350="AUGUST"),--(X1:X350>1),--(X1:X350<1000))

Help!
srain

 

[Guest]

Try splitting it apart to see if you can find the problems

=SUMPRODUCT(--(Figures!A1:A350="AUGUST"))
=SUMPRODUCT(--(Figures!A1:A350="AUGUST"),--(Figures!X1:X350>1))
=SUMPRODUCT(--(Figures!A1:A350="AUGUST"),--(Figures!X1:X350>1),--(Figures!X1:X350<1000))

 

[Guest]

Thanx for your help! It works now!
Cheers!
Srain