Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
test data in two columns, return totals
Hi,
I would like to test numbers in two columns against each other and count the amount. EG - how many in column A within interval 1 to 2 but only if number in column B (same row) is within interval 3 to 4. Columns are very long and simply want to know how many rows match my criteria. Can do this as a macro, but would like to use worksheet functions. If you know, please tell me the names of the functions that i would need to use. Don't need exact statements unless what I am asking is complex. Eugene |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
test data in two columns, return totals
try:
=SUMPRODUCT(--(A1:A71),--(A1:A7<2),--(B1:B73),--(B1:B7<4)) change ranges as needed and change < to <= and to = if needed. "eugene" wrote: Hi, I would like to test numbers in two columns against each other and count the amount. EG - how many in column A within interval 1 to 2 but only if number in column B (same row) is within interval 3 to 4. Columns are very long and simply want to know how many rows match my criteria. Can do this as a macro, but would like to use worksheet functions. If you know, please tell me the names of the functions that i would need to use. Don't need exact statements unless what I am asking is complex. Eugene |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
test data in two columns, return totals
thanks, that's easy
-- eugene "JMB" wrote: try: =SUMPRODUCT(--(A1:A71),--(A1:A7<2),--(B1:B73),--(B1:B7<4)) change ranges as needed and change < to <= and to = if needed. "eugene" wrote: Hi, I would like to test numbers in two columns against each other and count the amount. EG - how many in column A within interval 1 to 2 but only if number in column B (same row) is within interval 3 to 4. Columns are very long and simply want to know how many rows match my criteria. Can do this as a macro, but would like to use worksheet functions. If you know, please tell me the names of the functions that i would need to use. Don't need exact statements unless what I am asking is complex. Eugene |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
test data in two columns, return totals
quite welcome
"eugene" wrote: thanks, that's easy -- eugene "JMB" wrote: try: =SUMPRODUCT(--(A1:A71),--(A1:A7<2),--(B1:B73),--(B1:B7<4)) change ranges as needed and change < to <= and to = if needed. "eugene" wrote: Hi, I would like to test numbers in two columns against each other and count the amount. EG - how many in column A within interval 1 to 2 but only if number in column B (same row) is within interval 3 to 4. Columns are very long and simply want to know how many rows match my criteria. Can do this as a macro, but would like to use worksheet functions. If you know, please tell me the names of the functions that i would need to use. Don't need exact statements unless what I am asking is complex. Eugene |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return the data from 3 columns | Excel Worksheet Functions | |||
Match two columns, return a third piece of data | Excel Discussion (Misc queries) | |||
Match data in 2 columns and return data from 3rd column | Excel Worksheet Functions | |||
If value in data range (multiple columns) return row | Excel Discussion (Misc queries) | |||
test a range of cells and return an adjacent value | Excel Worksheet Functions |