Charting a range of data
 

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

Charting a range of data
 

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



"srain001" wrote:

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

Charting a range of data
 

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.

"Barb Reinhardt" wrote:

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



"srain001" wrote:

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

Charting a range of data
 

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:X1001),--(X1:X100<100))

--
HTH,
Barb Reinhardt



"srain001" wrote:

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.

"Barb Reinhardt" wrote:

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



"srain001" wrote:

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

Charting a range of data
 

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:X3501),--(X1:X350<1000))

Help!
srain

"Barb Reinhardt" wrote:

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:X1001),--(X1:X100<100))

--
HTH,
Barb Reinhardt



"srain001" wrote:

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.

"Barb Reinhardt" wrote:

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



"srain001" wrote:

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

Charting a range of data
 

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

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

--
HTH,
Barb Reinhardt



"srain001" wrote:


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:X3501),--(X1:X350<1000))

Help!
srain

"Barb Reinhardt" wrote:

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:X1001),--(X1:X100<100))

--
HTH,
Barb Reinhardt



"srain001" wrote:

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.

"Barb Reinhardt" wrote:

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



"srain001" wrote:

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

Charting a range of data
 

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

"Barb Reinhardt" wrote:

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

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

--
HTH,
Barb Reinhardt



"srain001" wrote:


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:X3501),--(X1:X350<1000))

Help!
srain

"Barb Reinhardt" wrote:

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:X1001),--(X1:X100<100))

--
HTH,
Barb Reinhardt



"srain001" wrote:

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.

"Barb Reinhardt" wrote:

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



"srain001" wrote:

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