Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range Names / Charting | Excel Discussion (Misc queries) | |||
Defining maximum value from a named range for charting purposes | Charts and Charting in Excel | |||
Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
Charting only Used Range with Named Ranges | Charts and Charting in Excel | |||
charting data across a range of worksheets | Charts and Charting in Excel |